如果改变默认安装路径，则需要 1）/etc/my.cnf、/etc/init.d/mysqld中修改 basedir='/apps/mysql' datadir='/apps/mysql/data' 2）创建ln mkdir -p /usr/local/mysql/bin ln -s /apps/mysql/bin/mysqld /usr/local/mysql/bin/mysqld
| [root@localhost mysql]$ [root@localhost mysql]$ cp -a ./support-files/my-default.cnf /etc/my.cnf [root@localhost mysql]$ cp -a ./support-files/mysql.server /etc/init.d/mysqld [root@localhost mysql]$ cd bin/ [root@localhost bin]# ./mysqld_safe --user=mysql & [1] 2932 [root@localhost bin]# 2016-06-01T22:27:09.708557Z mysqld_safe Logging to '/usr/local/mysql/data/localhost.localdomain.err'. 2016-06-01T22:27:09.854913Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data [root@localhost bin]# /etc/init.d/mysqld restart Shutting down MySQL..2016-06-01T22:27:50.498694Z mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.localdomain.pid ended SUCCESS! Starting MySQL. SUCCESS! [1]+ Done ./mysqld_safe --user=mysql [root@localhost bin]$ //设置开机启动 [root@localhost bin]$ chkconfig --level 35 mysqld on [root@localhost bin]$ |
6.初始化密码
mysql5.7会生成一个初始化密码，而在之前的版本首次登陆不需要登录。
| [root@localhost bin]$ cat /root/.mysql_secret # Password set for user 'root@localhost' at 2016-06-01 15:23:25 ,xxxxxR5H9 [root@localhost bin]$./mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 Server version: 5.7.12 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('123456'); Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) |
7.添加远程访问权限
| 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> select host, user from user; +-----------+-----------+ | host | user | +-----------+-----------+ | % | root | | localhost | mysql.sys | +-----------+-----------+ //一定要重启才会生效。 /etc/init.d/mysqld restart |
遇到的问题：
找不到mysql.sock，mysql.sock丢失问题解决方法
连接Mysql时，机器上找不到mysql.sock文件你可以简单地通过重启服务器重新创建得到它。因为服务器在启动时重新创建它。
| [root@localhost mysql-5.7.13]# ./bin/mysql_install_db --user=mysql 2016-06-26 02:47:09 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize 2016-06-26 02:47:09 [ERROR] The data directory needs to be specified. |
