Category: Handbook
-
MySQL DBA Hand Book
Connect MySQL DB: mysql> mysql -u root –socket=/var/lib/mysql/mysql.sock -p Enter password:_ Check Running Process List: mysql> show full processlist \G Create User: mysql> create user ‘account_name’@’Ip_address or %’ IDENTIFIED BY ‘**********’; Alter a User: mysql> alter user ‘root’@’localhost’ identified by ‘Secure@123’; Grant Privilege’s to the Mysql User: mysql> grant all privileges on *.* to account_name; mysql> flush privileges; mysql> grant create, select, insert on *…