达州做网站
大橙子网站建设，新征程启航
为企业提供网站建设、域名注册、服务器等服务
MySQL5.7.15安装(二进制版本)-创新互联
0.创建mysql用户和组信息
本文题目：MySQL5.7.15安装(二进制版本)-创新互联
文章URL：http://dzwzjz.com/article/dsggjp.html
[root@gxoradb1 ~]# groupadd mysql
[root@gxoradb1 ~]# useradd -r -g mysql -s /bin/false mysql
1.指定安装目录[root@gxoradb1 ~]# cd /usr/local
[root@gxoradb1 local]# ls
mysql-advanced-5.7.15-linux-glibc2.5-x86_64.tar.gz
2.解压mysql[root@gxoradb1 local]# tar -zxvf mysql-advanced-5.7.15-linux-glibc2.5-x86_64.tar.gz
[root@gxoradb1 local]# mv mysql-advanced-5.7.15-linux-glibc2.5-x86_64/ mysql-5.7.15
[root@gxoradb1 local]# ln -s mysql-5.7.15 mysql
[root@gxoradb1 local]# ls -la
lrwxrwxrwx 1 root root 12 Oct 4 14:58 mysql -> mysql-5.7.15
drwxr-xr-x 9 root root 4096 Oct 4 14:56 mysql-5.7.15
3.调整目录权限[root@gxoradb1 local]# cd mysql
[root@gxoradb1 mysql]# mkdir mysql-files[root@gxoradb1 mysql]# chmod 750 mysql-files
[root@gxoradb1 mysql]# chown -R mysql:mysql .
The mysql-files directory provides a convenient location to use as the value of the secure_file_priv system variable that limits import/export operations to a specific directory.
4.初始化mysql[root@gxoradb1 mysql]# bin/mysqld --initialize --user=mysql2016-10-04T07:07:05.044029Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-10-04T07:07:05.351321Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-10-04T07:07:05.396915Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-10-04T07:07:05.454329Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 2825c52a-8a01-11e6-abb2-080027b5eb23.
2016-10-04T07:07:05.456104Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-10-04T07:07:06.265334Z 0 [Warning] CA certificate ca.pem is self signed.
2016-10-04T07:07:06.503976Z 1 [Note] A temporary password is generated for root@localhost: <5Tk+Gs7frb7 //临时口令[root@gxoradb1 mysql]# bin/mysql_ssl_rsa_setup
5.调整目录权限[root@gxoradb1 mysql]# chown -R root .
[root@gxoradb1 mysql]# chown -R mysql data mysql-files
6.启动mysql[root@gxoradb1 mysql]# bin/mysqld_safe --user=mysql &
[1] 11211
[root@gxoradb1 mysql]# 2016-10-04T07:10:20.032700Z mysqld_safe Logging to '/usr/local/mysql/data/gxoradb1.err'.
2016-10-04T07:10:20.058270Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
7.创建自启动脚本[root@gxoradb1 mysql]# cp support-files/mysql.server /etc/init.d/mysql.server
[root@gxoradb1 mysql]# chkconfig --add mysql.server
[root@gxoradb1 mysql]# chkconfig --list mysql.server
mysql.server 0:off 1:off 2:on 3:on 4:on 5:on 6:off
8.登录mysql数据库[root@gxoradb1 ~]# mysql -u root -h localhost -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.15-enterprise-commercial-advanced
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
9.修改root用户口令mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'oracle';mysql> set password for 'root'@'localhost'=password('oracle');
| Directory | Contents of Directory |
|---|---|
bin,scripts | mysqld server, client and utility programs |
data | Log files, databases |
docs | MySQL manual in Info format |
man | Unix manual pages |
include | Include (header) files |
lib | Libraries |
share | Miscellaneous support files, including error messages, sample configuration files, SQL for database installation |
另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。
本文题目：MySQL5.7.15安装(二进制版本)-创新互联
文章URL：http://dzwzjz.com/article/dsggjp.html