貴州網站建設公司ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: YES
解決方法：
利用mysql安裝時的默認用戶名登錄mysql后， 輸入以下命令修改root密碼
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
2. 授予用戶權限
GRANT ALL PRIVILEGES ON *.* TO 'jiang'@'%' IDENTIFIED BY '1';
flush privileges;
下面的內容沒有用到
一.有時可以直接輸入命令: mysql進入數據庫
啟動數據庫：# mysqld_safe &
二.查看用戶命令:
mysql> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> select host,user from mysql.user;//show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)mysql>
刪除用戶
mysql>Delete FROM user Where User='test' and Host='localhost'; mysql>flush privileges; mysql>drop database testDB; //刪除用戶的數據庫刪除賬戶及權限：>drop user 用戶名@'%'; >drop user 用戶名@ localhost;
創建用戶
mysql> create user 'root'@'%' identified by '1';# %代表所有端口Query OK, 0 rows affected (0.07 sec)mysql> select host,user from mysql.user;+-----------+------------------+| host | user |+-----------+------------------+| % | root || % | usrabc || localhost | mysql.infoschema || localhost | mysql.session || localhost | mysql.sys |+-----------+------------------+5 rows in set (0.00 sec)
查看數據庫列表：
mysql> show databases;+--------------------+| Database |+--------------------+| information_schema |+--------------------+1 row in set (0.00 sec)mysql>
作者：江期玉
來源鏈接：https://www.cnblogs.com/jiangfeilong/p/10555185.html
