安装centos7后,准备msyql安装包
1.解压安装包并移动到mysql
tar -zxvf mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.16-linux-glibc2.5-x86_64/ mysql
2.创建用户...
groupadd mysql
useradd -r -g mysql mysql -s /sbin/nologin (创建mysql用户并设置不可登录)
chown -R mysql.mysql /usr/local/mysql/(可能需要自行创建myslq文件夹)
3.在mysql文件夹下创建data文件夹
cd mysql
mkdir data
4.配置/etc/my.cnf(可根据实际情况修改)
一般不设置权限,如果启动错误可以:chmod 644 /etc/my.cnf
[mysqld]
#skip-grant-tables
max_allowed_packet = 20M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
lower_case_table_names = 2
character-set-server=utf8
collation-server=utf8_general_ci
basedir=/mnt/labour/mysql
datadir=/mnt/labour/mysql/data
port = 3306
[mysql]
default-character-set = utf8
socket=/tmp/mysql.sock
[mysql.server]
default-character-set = utf8
[mysqld_safe]
default-character-set = utf8
[client]
default-character-set = utf8
socket=/tmp/mysql.sock
5.切换到mysql/support-files目录下
cd /mnt/labour/mysql/support-files
sudo cp -a mysql.server /etc/init.d/mysqld
6.为了保证启动不出错要确认mysql文件夹下所有文件的用户和组都是mysql且data目录要有写的权限
Linux 修改指定文件夹及子文件夹的用户及用户组
命令:
chown -R 用户组:用户 指定文件夹目录
7.初始化数据
cd mysql
1. yum install libaio*
2. ./bin/mysqld --initialize --basedir=/mnt/labour/mysql --datadir=/mnt/labour/mysql/data
记住loclhost后面的密码
8.首次登陆
bin/mysql -uroot –p
设置密码命令:
set password =password('root');
修改远程连接
改表法
use mysql;
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;
9.错误
检查mysql所属的用户和组,参考6
检查my.cnf权限,参考4
(如果在
mysql FLUSH PRIVILEGES;时候提示:ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
解决方案:
drop table if exists mysql.servers;
CREATE TABLE `servers` (
`Server_name` char(64) NOT NULL,
`Host` char(64) NOT NULL,`Db` char(64) NOT NULL,
`Username` char(64) NOT NULL,
`Password` char(64) NOT NULL,
`Port` int(4) DEFAULT NULL,
`Socket` char(64) DEFAULT NULL,
`Wrapper` char(64) NOT NULL,
`Owner` char(64) NOT NULL,
PRIMARY KEY (`Server_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';
后重新mysql FLUSH
)