安装mysql时的一些问题_MySQL

bitsCN.com

安装mysql时的一些问题

 

问题如下:

 

 /usr/bin/mysql_secure_installation

 

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL

      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

 

In order to log into MySQL to secure it, we'll need the current

password for the root user.  If you've just installed MySQL, and

you haven't set the root password yet, the password will be blank,

so you should just press enter here.

 

Enter current password for root (enter for none): 

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

 

解决办法:

 

登陆mysql

 

如果无法登陆mysql 可以在my.cnf中增加skip-grant-tables;跳过验证，登陆mysql后重新设置一下密码

 

set password=password('123456');

 

然后运行

 

/usr/bin/mysql_secure_installation

 

进行安全设置就可以了

 

搞定收工

 

bitsCN.com