red hat mysql 安装_Red Hat Linux安装单机版MySQL数据库

创建数据data目录并修改权限

[root@orcl mysql]# mkdir data

[root@orcl mysql]# chown -R mysql.mysql .

[root@orcl mysql]# ll

total 56

drwxr-xr-x 2 mysql mysql 4096 Jul 12 2016 bin

-rw-r--r-- 1 mysql mysql 17987 Jul 12 2016 COPYING

drwxr-xr-x 2 mysql mysql 4096 Feb 4 21:49 data

drwxr-xr-x 2 mysql mysql 4096 Jul 12 2016 docs

drwxr-xr-x 3 mysql mysql 4096 Jul 12 2016 include

drwxr-xr-x 5 mysql mysql 4096 Jul 12 2016 lib

drwxr-xr-x 4 mysql mysql 4096 Jul 12 2016 man

-rw-r--r-- 1 mysql mysql 2478 Jul 12 2016 README

drwxr-xr-x 28 mysql mysql 4096 Jul 12 2016 share

drwxr-xr-x 2 mysql mysql 4096 Jul 12 2016 support-files

切换目录，并初始化数据库(nunaSZDJn1,/为初始密码 牢记)

[root@orcl bin]#cd /usr/local/mysql/bin

[root@orcl bin]# ./mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --initialize

2017-02-04T13:50:51.147996Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2017-02-04T13:50:51.155737Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.

2017-02-04T13:50:51.557455Z 0 [Warning] InnoDB: New log files created, LSN=45790

2017-02-04T13:50:51.627576Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2017-02-04T13:50:51.704370Z 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: f0ed6926-eae0-11e6-a746-005056be5b20.

2017-02-04T13:50:51.706481Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2017-02-04T13:50:51.709430Z 1 [Note] A temporary password is generated for root@localhost: nunaSZDJn1,/

basedir为安装目录 datadir为存放数据路径

下面修改权限

[root@orcl local]# pwd

/usr/local

[root@orcl local]# ll

total 598100

drwxr-xr-x. 2 root root 4096 Jan 8 14:06 bin

drwxr-xr-x. 2 root root 4096 Jun 28 2011 etc

drwxr-xr-x. 2 root root 4096 Jun 28 2011 games

drwxr-xr-x. 2 root root 4096 Jun 28 2011 include

drwxr-xr-x. 2 root root 4096 Jun 28 2011 lib

drwxr-xr-x. 2 root root 4096 Jun 28 2011 libexec

drwxr-xr-x 10 mysql mysql 4096 Feb 4 21:49 mysql

-rw-r--r-- 1 root root 612408403 Feb 4 21:32 mysql-5.7.14-linux-glibc2.5-i686.tar.gz

drwxr-xr-x. 2 root root 4096 Jun 28 2011 sbin

drwxr-xr-x. 5 root root 4096 Jul 3 2015 share

drwxr-xr-x. 2 root root 4096 Jun 28 2011 src

[root@orcl local]# chown -R root mysql

[root@orcl local]# ll

total 598100

drwxr-xr-x. 2 root root 4096 Jan 8 14:06 bin

drwxr-xr-x. 2 root root 4096 Jun 28 2011 etc

drwxr-xr-x. 2 root root 4096 Jun 28 2011 games

drwxr-xr-x. 2 root root 4096 Jun 28 2011 include

drwxr-xr-x. 2 root root 4096 Jun 28 2011 lib

drwxr-xr-x. 2 root root 4096 Jun 28 2011 libexec

drwxr-xr-x 10 root mysql 4096 Feb 4 21:49 mysql

-rw-r--r-- 1 root root 612408403 Feb 4 21:32 mysql-5.7.14-linux-glibc2.5-i686.tar.gz

drwxr-xr-x. 2 root root 4096 Jun 28 2011 sbin

drwxr-xr-x. 5 root root 4096 Jul 3 2015 share

drwxr-xr-x. 2 root root 4096 Jun 28 2011 src

[root@orcl local]# chown -R mysql mysql/data/ 将数据权限修改回来

[root@orcl local]cd mysql/bin/

[root@orcl bin]# ./mysqld_safe --user=mysql &

再开启另一个命令窗口

[root@orcl ~]# ps -ef|grep mysql 服务起来了

root 11624 10029 0 21:57 pts/0 00:00:00 /bin/sh ./mysqld_safe --user=mysql

mysql 11849 11624 2 21:57 pts/0 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/orcl.err --pid-file=/usr/local/mysql/data/orcl.pid --socket=/var/lib/mysql/mysql.sock --port=22101

root 11907 11885 0 21:57 pts/1 00:00:00 grep mysql

[root@orcl ~]#

[root@orcl ~]# clear

[root@orcl ~]# cd /usr/local/mysql/bin/

[root@orcl bin]# ./mysql -uroot -p 进入mysql命令窗口回车后，需要输入初始化数据库时显示的密码

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.7.14

Copyright (c) 2000, 2016, 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> SET PASSWORD = PASSWORD('jfhr@rhvh23'); 修改密码

Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> use mysql; 进入mysql数据库

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@orcl bin]# ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

[root@orcl bin]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

[root@orcl bin]# vim /etc/init.d/mysql

修改

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

设置开机启动与服务命令

[root@orcl bin]# cd /etc/init.d/

[root@orcl init.d]# chkconfig --add mysql

[root@orcl init.d]# chkconfig --level 2345 mysql on

[root@orcl init.d]# chmod 777 mysql

[root@orcl init.d]#

关闭第一个窗口，在第二个窗口里面删进程

[root@orcl init.d]# ps -ef|grep mysql

root 11624 10029 0 21:57 pts/0 00:00:00 /bin/sh ./mysqld_safe --user=mysql

mysql 11849 11624 0 21:57 pts/0 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/orcl.err --pid-file=/usr/local/mysql/data/orcl.pid --socket=/var/lib/mysql/mysql.sock --port=22101

root 12110 11885 0 22:03 pts/1 00:00:00 vim /etc/init.d/mysql

root 12162 11885 0 22:06 pts/1 00:00:00 grep mysql

[root@orcl init.d]# kill -9 11624

[root@orcl init.d]# kill -9 11849

[root@orcl init.d]# ps -ef|grep mysql

root 12110 11885 0 22:03 pts/1 00:00:00 vim /etc/init.d/mysql

root 12167 11885 0 22:06 pts/1 00:00:00 grep mysql

[root@orcl init.d]#

[root@orcl init.d]# service mysql start 启动数据库

Starting MySQL [ OK ]

[root@orcl init.d]# ps -ef|grep mysql

root 12110 11885 0 22:03 pts/1 00:00:00 vim /etc/init.d/mysql

root 12211 1 0 22:07 pts/1 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/orcl.pid

mysql 12452 12211 0 22:07 pts/1 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/orcl.err --pid-file=/usr/local/mysql/data/orcl.pid --socket=/var/lib/mysql/mysql.sock --port=22101

root 12495 11885 0 22:08 pts/1 00:00:00 grep mysql

[root@orcl init.d]#

单机版数据就到此结束，关于主从和集群会在下次更新时发布。

如果出现Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/data/dxwx140.pid)

chown -R mysql:mysql data

chmod -R 755 /usr/local/mysql/data