初次安装
安装命令
sudo apt-get install mysql-server mysql-client
2初始密码查看
sudo vim /etc/mysql/debian.cnf
结果如下:随机的user和password,每个人的都不同
[client]
host = localhost
user = debian-sys-maint
password = dMkUsn4cnEJienG7
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = dMkUsn4cnEJienG7
socket = /var/run/mysqld/mysqld.sock
用随机账号密码进入mysql
hz@ubuntu:~$ mysql -udebian-sys-maint -pdMkUsn4cnEJienG7
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.7.24-0ubuntu0.18.04.1 (Ubuntu)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
修改密码:出现下面提示即为成功
mysql> update mysql.user set authentication_string=PASSWORD('newpassword'), plugin='mysql_native_password' where user='root';
Query OK, 0 rows affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 1
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
重启mysql
sudo service mysql restart
直接用设置好的账号密码登录即可
mysql -uroot -p
enter password:
ubantu下的Mysql重装
首先删除mysql:
sudo apt-get remove mysql-*
然后清理残留的数据
dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P
它会跳出一个对话框,你选择yes就好了
然后安装mysql
sudo apt-get install mysql-client mysql-server
安装的时候会提示要设置root密码,如果你没有在卸载的时候去清理残留数据是不会提示你去设置root密码的
检查mysql是不是在运行
sudo service mysql status
一般安装完成之后都是会自动运行的。
如果没有运行你可以
sudo service mysql start
运行它