Ubuntu安装使用mysql

sudo apt-get install mysql-server

apt-get isntall mysql-client

sudo cat /etc/mysql/debian.cnf    打开 /etc/mysql/debian.cnf 。

内容如下：

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = i5zFhfYNFTnTfOqo
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = i5zFhfYNFTnTfOqo
socket   = /var/run/mysqld/mysqld.sock

我们找到client的user和password，然后在终端输入 mysql -u debian-sys-maint -p 然后回车输入password  这里是i5zFhfYNFTnTfOqo

第一次可能是我改了什么一直发生错误,之后卸载重装ok

参考链接

https://www.jianshu.com/p/35e7af7db96a

 

其他

The problem is, your GRANT statement uses IDENTIFIED BY PASSWORD clause, and in this case mysql expect to get a hashed password, not a plaintext one. Use IDENTIFIED BY 'your password' instead, if you wish to supply a plaintext password.

问题是，GRANT语句使用了标识密码子句，在本例中MySQL希望获得一个散列密码，而不是明文密码。如果您希望提供明文密码，请使用“您的密码”标识。