1,创建用户分配权限:
创建用户组: groupadd mysql
创建用户并且分配组: useradd -g mysql mysql
设置用户密码:passwd mysql
给用户组授权:chown -R mysql:mysql /usr/local/ (很重要,可能会导致启动不成功)
2,解压mysql压缩包
解压命令: tar -zxvf mysql5.6.27back.tar.gz
重命名文件:mv 源文件名 修改名 (mv mysql-5.6.17-linux-glibc2.5-x86_64 mysql)
3,进入/usr/local/mysql 修改配置文件
vim my.cnf (如果没有就新建)
[client]
default-character-set=utf8
socket=/usr/local/mysql/tmp/mysql.sock
[mysql]
default-character-set=utf8
[mysqld]
socket=/usr/local/mysql/tmp/mysql.sock
tmpdir=/usr/local/mysql/tmp/
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
symbolic-links=0
character_set_server=utf8
[mysqld_safe]
default-character-set=utf8
log-error=/usr/local/mysql/logs/mysqld.log
pid-file=/usr/local/mysql/run/mysqld/mysqld.pid
授权: chmod 644 my.cnf
4,进入/usr/local/mysql 建立目录
mkdir tmp
mkdir logs
mkdir -p run/mysqld
5,执行./scripts/mysql_install_db --user=mysql
报错解决:
(1)FATAL ERROR: please install the following Perl modules before executing ./scripts/mysql_install_db:
解决方法是安装autoconf库
执行命令:yum -y install autoconf
(2)Installing MySQL system tables.../usr/local/mysql/bin/mysqld: error while loading shared
原因:缺少libaio库文件
解决方法:yum install libaio* -y
6,检测安装是否成功,启动mysql,进入/usr/local/mysql执行:
bin/mysqld_safe &
7,启动:./support-files/mysql.server start
8,用root用户登录MySQL并修改mysql用户的密码在/usr/local/mysql/bin目录执行:
./mysql -h 127.0.0.1 -uroot
修改密码:
重置密码的第一步就是跳过MySQL的密码认证过程,方法如下:
#vim /etc/my.cnf(注:windows下修改的是my.ini)
在文档内搜索mysqld定位到[mysqld]文本段:
/mysqld(在vim编辑状态下直接输入该命令可搜索文本内容)
在[mysqld]后面任意一行添加“skip-grant-tables”用来跳过密码验证的过程
之后执行步骤8,连接成功执行下面的操作:
a: use mysql;
b: UPDATE user SET PASSWORD=PASSWORD('123456') WHERE USER='mysql';
c: flush privileges;
d: 给用户远程连接的权限:
grant all privileges on *.* to mysql @"%" identified by "123456" with grant option;
grant all privileges on *.* to root@'%' identified by 'root'; flush privileges;
use mysql;
UPDATE user SET Password = password ( 'root' ) WHERE User = 'root' ;
密码登录:./mysql -uroot -h 127.0.0.1 -p
添加系统服务:
cp support-files/mysql.server /etc/init.d/mysql
service mysql start
ubuntu 下安装mysql:
1. sudo apt-get install mysql-server
2. sudo apt-get isntall mysql-client
3. sudo apt-get install libmysqlclient-dev
开启远程访问:
1修改绑定地址:/etc/mysql/mysql.conf.d/mysqld.cnf,将bind-address = 127.0.0.1,修改为bind-address = 0.0.0.0,需要重启sudo service mysql restart
2登陆:mysql -u root -p
3修改root 远程访问权限:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;
%表示任何地址,也可以指定地址访问