mysql ubuntu安装mysql和重置root密码
ubuntu上安装mysql非常简单只需要几条命令就可以完成。
1. sudo apt-get install mysql-server
2. apt-get isntall mysql-client
mysql --version 查看是否安装成功
mysql -u root -p
--------------------------------------------
root未设置密码
进入 /etc/mysql/my.cnf
末尾加 skip-grant-tables
保存
重启mysql
把加的删了再保存 ---启动mysql
修改mysql:
MySQL> UPDATE mysql.user SET Password=PASSWORD('新密码') where USER='root';
MySQL> flush privileges;
MySQL> exit
MySQL> flush privileges;
MySQL> exit
---创建用户同时授权
mysql> grant all privileges on mq.* to test@localhost identified by '1234';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)