linux安装Mysql

概览：

• 安装Mysql
• 修改密码
• 安装phpMyAdmin
  • phpMyAdmin
  • 软连接

安装Mysql

sudo apt install mysql-server

现在的mysql，默认安装时不提供设置密码。

所以，这能以默认用户登录来添加用户·及修改密码。

sudo nano /etc/mysql/debian.cnf

内容像这样

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

以上信息可以得出：

用户名：debian-sys-maint

密码：JVSGL6hCuThRoMcX

查看用户列表

select user,host from mysql.user;

输出

mysql> select user,host from mysql.user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| debian-sys-maint | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)

修改密码

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> select user,plugin from user;
+------------------+-----------------------+
| user             | plugin                |
+------------------+-----------------------+
| root             | auth_socket           |
| mysql.session    | mysql_native_password |
| mysql.sys        | mysql_native_password |
| debian-sys-maint | mysql_native_password |
+------------------+-----------------------+
4 rows in set (0.00 sec)


mysql> update user set authentication_string=password("88888888"),plugin='mysql_native_password' where user='root';
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 1

mysql> select user,plugin from user;
+------------------+-----------------------+
| user             | plugin                |
+------------------+-----------------------+
| root             | mysql_native_password |
| mysql.session    | mysql_native_password |
| mysql.sys        | mysql_native_password |
| debian-sys-maint | mysql_native_password |
+------------------+-----------------------+
4 rows in set (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

成功

mardan@Mardan666-WS:~$ mysql -u root -p88888888
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 5
Server version: 5.7.27-0ubuntu0.18.04.1 (Ubuntu)

Copyright (c) 2000, 2019, 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> 

安装phpMyAdmin

sudo apt install apache2
sudo apt install phpmyadmin
sudo apt install libapache2-mod-php # apache2 需要此模块

软连接

sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin