在Kylin中安装MySQL

心有阳光 2023-02-20

1059

下载安装包mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar

安装

解压

[root@192 mysql]# tar xvf mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar 
mysql-community-client-5.7.33-1.el7.x86_64.rpm
mysql-community-common-5.7.33-1.el7.x86_64.rpm
mysql-community-devel-5.7.33-1.el7.x86_64.rpm
mysql-community-embedded-5.7.33-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.33-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.33-1.el7.x86_64.rpm
mysql-community-libs-5.7.33-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.33-1.el7.x86_64.rpm
mysql-community-server-5.7.33-1.el7.x86_64.rpm
mysql-community-test-5.7.33-1.el7.x86_64.rpm


[root@192 mysql]# ls
mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar        mysql-community-devel-5.7.33-1.el7.x86_64.rpm            mysql-community-embedded-devel-5.7.33-1.el7.x86_64.rpm  mysql-community-server-5.7.33-1.el7.x86_64.rpm
mysql-community-client-5.7.33-1.el7.x86_64.rpm  mysql-community-embedded-5.7.33-1.el7.x86_64.rpm         mysql-community-libs-5.7.33-1.el7.x86_64.rpm            mysql-community-test-5.7.33-1.el7.x86_64.rpm
mysql-community-common-5.7.33-1.el7.x86_64.rpm  mysql-community-embedded-compat-5.7.33-1.el7.x86_64.rpm  mysql-community-libs-compat-5.7.33-1.el7.x86_64.rpm

[root@192 mysql]# yum localinstall mysql-community-common-5.7.33-1.el7.x86_64.rpm

[root@192 mysql]# yum localinstall mysql-community-libs-5.7.33-1.el7.x86_64.rpm

[root@192 mysql]# yum localinstall mysql-community-client-5.7.33-1.el7.x86_64.rpm

[root@192 mysql]# yum localinstall mysql-community-server-5.7.33-1.el7.x86_64.rpm

查看版本

[root@192 mysql]# mysql -V

启动

[root@192 mysql]# systemctl start mysqld

查看状态

[root@192 mysql]# systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Fri 2022-02-18 23:19:16 CST; 16s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 311324 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
  Process: 312086 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
 Main PID: 312089 (mysqld)
    Tasks: 27
   Memory: 290.6M
   CGroup: /system.slice/mysqld.service
           └─312089 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

2月 18 23:19:06 192.168.254.140 systemd[1]: Starting MySQL Server...
2月 18 23:19:12 192.168.254.140 mysqld_pre_systemd[311324]: mysqld: Out of memory (Needed 4294967200 bytes)
2月 18 23:19:16 192.168.254.140 systemd[1]: Started MySQL Server.

开启远程控制

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> update user set Host='%' where User='root';  
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

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

mysql> exit

[root@192 ~]# systemctl restart mysqld

mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";

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

mysql> exit

[root@192 mysql]# systemctl restart mysqld

配置默认编码为utf8

修改 /etc/my.cnf

mysql> show variables like '%char%';
+--------------------------------------+----------------------------+
| Variable_name                        | Value                      |
+--------------------------------------+----------------------------+
| character_set_client                 | utf8                       |
| character_set_connection             | utf8                       |
| character_set_database               | latin1                     |
| character_set_filesystem             | binary                     |
| character_set_results                | utf8                       |
| character_set_server                 | latin1                     |
| character_set_system                 | utf8                       |
| character_sets_dir                   | /usr/share/mysql/charsets/ |
| validate_password_special_char_count | 1                          |
+--------------------------------------+----------------------------+
9 rows in set (0.00 sec)

# 可以看到，当前数据库客户端默认是utf8编码，服务端是latin1编码

[root@192 ~]# vim /etc/my.cnf

# 在文件内的[mysqld]下增加如下两行设置

character_set_server=utf8
init_connect='SET NAMES utf8'