创建数据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