当前位置:Gxlcms >
数据库问题 >
安装Mysql遇到的问题: libaio.so.1()(64bit) is needed by MySQL ***
安装Mysql遇到的问题: libaio.so.1()(64bit) is needed by MySQL ***
时间:2021-07-01 10:21:17
帮助过:5人阅读
解决方法:
方法一:
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’;
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>
错误信息
MySql5.6操作时报错:
You must SET PASSWORD before executing this statement解决
mysql> SET PASSWORD = PASSWORD(‘123456‘);
Query OK, 0 rows affected (0.03 sec)
mysql> create database roger;
Query OK, 1 row affected (0.00 sec)
也就是用mysql> SET PASSWORD = PASSWORD(‘123456‘);这句话重新设置一次密码!
安装Mysql遇到的问题: libaio.so.1()(64bit) is needed by MySQL ***
标签: