本案例WORKSTATION 16 PRO测试安装
一、软件与版本
Lylin Server V10 Kylin-Server-10-SP2-x86-Release-Build09-20210524
Mysql8.2.0 mysql-8.2.0-linux-glibc2.28-x86_64.tar.xz
二、虚拟机配置
三、麒麟Lylin server v10安装
接受许可信息:32cc
四、设置IP
cd /etc/sysconfig/network-scripts/
ls
vi ifcfg-ens192
ifdown ens192
ifup ens192
ip addr
五、用Xshel连接Lylin Server V10
六、安装URL页面管理
dnf install -y cockpit cockpit-machines
1,启动cockpit
systemctl start cockpit.socket
2,设置开机启动
systemctl enable cockpit.socket
3,查看cockpit状态
systemctl status cockpit.socket
3,防火墙放行9090端口
firewall -cmd --permanent --add-port=9090/tcp
firewall-cmd --reload
七、下载与安装Mysql 8
1)安装下载与解压软件
yum install -y wget tar
2)下载Msql 8.2.0
cd /home
wget https://cdn.mysql.com//Downloads/MySQL-8.2/mysql-8.2.0-linux-glibc2.28-x86_64.tar.xz
3)解压mysql-8.2.0-linux-glibc2.28-x86_64.tar.xz(这里不要用tar -zxvf)
tar -xvf mysql-8.2.0-linux-glibc2.28-x86_64.tar.xz -C /usr/local
4)Mysql8 安装
cd /usr/local/
mv mysql-8.2.0-linux-glibc2.28-x86_64/ mysql
groupadd mysql
useradd -r -g mysql mysql
cd /usr/local/mysql
mkdir data
mkdir log
chown -R mysql:mysql /usr/local/mysql
chmod -R 755 /usr/local/mysql
vim /etc/my.cnf
5)my.cnf内容如下
[mysqld]
port=3306
datadir=/usr/local/mysql/data
log-error=/usr/local/mysql/log/mysql-err.log
socket=/usr/local/mysql/data/mysql.sock
pid-file=/usr/local/mysql/data/mysql.pid
user=root
default_authentication_plugin=mysql_native_password
basedir=/usr/local/mysql
lower_case_table_names = 1
sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
innodb_strict_mode=0
innodb_log_file_size = 512M
log_bin_trust_function_creators=1
#skip-grant-tables
# 禁止MySQL对外部连接进行DNS解析,使用这一选项可以消除MySQL进行DNS解析的时间。但需要注意,如果开启该选项,
# 则所有远程主机连接授权都要使用IP地址方式,否则MySQL将无法正常处理连接请求
#skip-networking
back_log = 600
# MySQL能有的连接数量。当主要MySQL线程在一个很短时间内得到非常多的连接请求/.
max_connections = 1000
max_connect_errors = 6000
# 对于同一主机,如果有超出该参数值个数的中断错误连接,则该主机将被禁止连接。如需对该主机进行解禁,执行:FLUSH HOST。
open_files_limit = 65535
table_open_cache = 128
max_allowed_packet = 400M
# 该变量之所以取较小默认值是一种预防措施,以捕获客户端和服务器之间的错误信息包,并确保不会因偶然使用大的信息包而导致内存溢出。
binlog_cache_size = 1M
# 一个事务,在没有提交的时候,产生的日志,记录到Cache中;等到事务提交需要提交的时候,则把日志持久化到磁盘
max_heap_table_size = 8M
# 定义了用户可以创建的内存表(memory table)的大小。这个值用来计算内存表的最大行数值。这个变量支持动态改变
tmp_table_size = 16M
#指定单个查询能够使用的缓冲区大小,默认1M
default-storage-engine = InnoDB
#[mysqldump]
#host=localhost
#user=root
#password=b4%XZCRQp-name-resolve
[client]
#socket=/tmp/mysql.sock
socket=/usr/local/mysql/data/mysql.sock
6)初始化mysql8
cd bin/
./mysqld --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql --initialize
ln -s /usr/local/mysql/bin/mysql /usr/bin
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
cd /usr/local/mysql
./bin/mysqld_safe &
7) 获取初始密码:
tail -1000f log/mysql-err.log
8)登陆、修改mysql密码与创建一个库
1,登录mysql
mysql -uroot -p
Enter password: !_u,StQeN5Uh 回车
2,修改root密码为“p@ssw0rd”
mysql> alter user 'root'@'localhost' identified by 'p@ssw0rd';
Query OK, 0 rows affected (0.01 sec)
3,刷新权限:
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
4,查询用户:
mysql> select user,host from mysql.user;
+----------------------+-----------+
| user | host |
+----------------------+-----------+
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+----------------------+-----------+
4 rows in set (0.00 sec)
5,修改允许远程连接:
mysql> update mysql.user set host = '%' where user = 'root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
6,刷新权限:
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> use mysql;
mysql> select user,host from user;
+---------------------+--------------+
| user | host |
+---------------------+--------------+
| root | % |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
+---------------------+--------------+
5 rows in set (0.00 sec)
7,创建一个测试数据库:
mysql> CREATE DATABASE `test`;
8,使用test库创建一个测试空表:
mysql> use test;
mysql> create table tb_mobile( mobile VARCHAR(20) comment'手机号码', time timestamp DEFAULT now() comment'时间' );
7,退出mysql:
mysql> quit;
Bye
9)设置开机启动
chkconfig --add mysqld
chkconfig mysqld on
systemctl restart mysqld