澳门在线威尼斯官方 > 电脑数据库 > 威尼斯澳门在线:statement的消除格局

原标题:威尼斯澳门在线:statement的消除格局

浏览次数:106 时间:2019-12-30

动用安全情势成功登入,然后改正密码,等于给MySql设置了密码。登入进去后,想询问全体存在的数据库测验下。获得的结果的确:

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

格外奇异啊,明明用密码登入进去了,怎么还提示必要密码。
参谋官方的二个文书档案,见

mysql> show databases;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
mysql> SET PASSWORD = PASSWORD('123456');
Query OK, 0 rows affected (0.00 sec)

mysql> show databases;
5 rows in set (0.00 sec)

也就是用mysql> SET PASSWOWranglerD = PASSWO凯雷德D('123456'State of Qatar;那句话再度安装二次密码!哎,搞得真费事啊。

一些童鞋也会超出如下问题:

那二日新装好的mysql在步入mysql工具时,总是有荒谬提醒:

# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
或者
# mysql -u root -p password 'newpassword'
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

今昔终于找到化解措施了。本来寻思重装的,将来不要了。
措施操作很简短,如下:
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWO酷威D('newpassword'State of Qatar where USEGL450='root' and host='root' or host='localhost';//把空的顾客密码都改过成非空的密码就能够了。
mysql> FLUSH PRIVILEGES;
mysql> quit # /etc/init.d/mysqld restart
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>

MySql5.6操作时报错:You must SET PASSWO途观D 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 PASSWOEvoqueD = PASSWOOdysseyD('123456'卡塔尔;那句话再次设置一次密码!就解决了。

本文由澳门在线威尼斯官方发布于电脑数据库,转载请注明出处:威尼斯澳门在线:statement的消除格局

关键词:

上一篇:已提交到MariaDB官方手册

下一篇:已提交到MariaDB官方手册