方法一:
[root@localhost ~]# mysql -uroot
MariaDB [(none)]> use mysql;
MariaDB [mysql]> UPDATE mysql.user SET password = PASSWORD(‘newpassward’) WHERE user = ‘root’;
MariaDB [mysql]> FLUSH PRIVILEGES;
方法二:
[root@localhost ~]# mysql -uroot
MariaDB [(none)]> use mysql;
MariaDB [mysql]> SET password=PASSWORD(‘newpassward’);
MariaDB [mysql]> FLUSH PRIVILEGES;
方法三:
[root@localhost ~]# mysqladmin -u root password ‘newpassword’
#如果root已经设置过密码,采用如下方法
[root@localhost ~]# mysqladmin -u root -p ‘oldpassword’ password ‘newpassword’
ERROR 1045 (28000): Access denied for user…错误的解决
刚刚安装好了mysql数据库,root用户登录没有问题,但是在创建了新的数据库后却无法登录,报“ERROR 1045 (28000): Access denied for user”这样的错误,下面对这个错误进行重演,首先以root用户登录:
也给了用户权限
MariaDB [(none)]> grant all privileges on proxy.* to proxyuser@'192.168.200.%' identified by '000000';
解决方法:
在网上找到了一种方法,登录数据库mysql,删除user表中user列为空格的行:
# mysql -uroot -proot
mysql> use mysql
Database changed
mysql> select host,user,password from user;
mysql> delete from user where user=' ';
Query OK, 2 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye