Mysql commands in Centos

Centos system mysql commands Centos system mysql forgot root user password: Step 1: (stop running mysql) [root @ CentOs5 ~] # Service mysqld stopstopstopping MySQL: [OK] Step 2: Use the "-- skip-grant-tables" parameter to restart mysql [root @ CentOs5 ~] # Mysqld_safe -- skip-grant-tables & [1] 23810 [root @ CentOs5 ~] # Starting mysqld daemon with databases from/var/lib/mysql
Step 3: log on to mysql with an account [root @ CentOs5 ~] # Mysql-u rootWelcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 1 Server version: 5.0.77 Source distributionType 'help; 'or' \ H' for help. type '\ C' to clear the buffer. step 4: change the user database mysql> use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with-ADatabase changed Step 5: change the password, remember to use the password () function for the password. Encryption. do not forget it !!! Mysql> update user set password = password ('admin123') where user = 'root'; Query OK, 1 row affected (0.04 sec) Rows matched: 1 Changed: 1 Warnings: 0 Step 6: refresh the permission table mysql> flush previleges; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'previleges' at line 1 mysql> flush privileges; Query OK, 0 rows affecte Step 7 of d (0.00 sec): Exit mysqlmysql> quitBye Step 8: restart mysql [root @ CentOs5 ~] # Service mysqld restart; STOPPING server from pid file/var/run/mysqld. pid100421 13:44:03 mysqld endedStopping MySQL: [OK] Starting MySQL: [OK] [1] + Done mysqld_safe -- skip-grant-tables Step 9: log on again with the changed password. [Root @ CentOs5 ~] # Mysql-u root-pEnter password: admin123Welcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 2 Server version: 5.0.77 Source distributionType 'help; 'or' \ H' for help. type '\ C' to clear the buffer. mysql> quitBye [root @ CentOs5 ~] #