Ubuntu安装MySQL
# 1. 更新包 sudo apt update # 2. 安装Mysql sudo apt install mysql-server # 3. 查看MySQL mysql -V
MySQL初始化配置
sudo mysql_secure_installation
配置项较多，如下所示：
- 我这里设置简单的密码：
henggao
#1 VALIDATE PASSWORD PLUGIN can be used to test passwords... Press y|Y for Yes, any other key for No: N (选择N ,不会进行密码的强校验) #2 Please set the password for root here... New password: (输入密码) Re-enter new password: (重复输入) #3 By default, a MySQL installation has an anonymous user, allowing anyone to log into MySQL without having to have a user account created for them... Remove anonymous users? (Press y|Y for Yes, any other key for No) : N (选择N，不删除匿名用户) #4 Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network... Disallow root login remotely? (Press y|Y for Yes, any other key for No) : N (选择N，允许root远程连接) #5 By default, MySQL comes with a database named 'test' that anyone can access... Remove test database and access to it? (Press y|Y for Yes, any other key for No) : N (选择N，不删除test数据库) #6 Reloading the privilege tables will ensure that all changes made so far will take effect immediately. Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y (选择Y，修改权限立即生效)
检查MySQL服务状态
systemctl status mysql.service
访问数据库
- 以root进入，密码：
henggao
sudo mysql -uroot -p #切换数据库 mysql>use mysql; #查询用户表命令： mysql>select User,authentication_string,Host from user; #查看状态 select host,user,plugin from user;
参考：
