安装前置文件:
yum -y install perl perl-devel
yum install -y perl-Data-Dumper
yum install libaio* -y
tar -zxvf mysql-advanced-5.6.21-linux-glibc2.5-x86_64.tar.gz -C /usr/local
cd /usr/local
mkdir mysql
mv mysql-advanced-5.6.21-linux-glibc2.5-x86_64/* mysql
groupadd mysql
useradd -g mysql mysql
chown -R mysql:mysql /usr/local/mysql
---初始化库
./scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
--添加mysql到服务开机启动
chkconfig --add mysqld
chkconfig --level 2345 mysqld on
---启动mysql 服务
service mysqld start
--添加PATH
vim /etc/profile
--在最后,添加:
export PATH="/usr/local/mysql/bin:$PATH"
--保存,退出,然后运行:
source /etc/profile
mysql -u root -p
报错 提示 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (1)
执行 ln -s /var/local/mysql/mysql.sock /tmp/mysql.sock
--修改ROOT密码
set password=PASSWORD('root');
FLUSH PRIVILEGES;
exit;
退出,再重新登录 设置远程登录
设置本机被远程连接
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;
yum -y install perl perl-devel
yum install -y perl-Data-Dumper
yum install libaio* -y
tar -zxvf mysql-advanced-5.6.21-linux-glibc2.5-x86_64.tar.gz -C /usr/local
cd /usr/local
mkdir mysql
mv mysql-advanced-5.6.21-linux-glibc2.5-x86_64/* mysql
groupadd mysql
useradd -g mysql mysql
chown -R mysql:mysql /usr/local/mysql
---初始化库
./scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
--添加mysql到服务开机启动
chkconfig --add mysqld
chkconfig --level 2345 mysqld on
---启动mysql 服务
service mysqld start
--添加PATH
vim /etc/profile
--在最后,添加:
export PATH="/usr/local/mysql/bin:$PATH"
--保存,退出,然后运行:
source /etc/profile
mysql -u root -p
报错 提示 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (1)
执行 ln -s /var/local/mysql/mysql.sock /tmp/mysql.sock
--修改ROOT密码
set password=PASSWORD('root');
FLUSH PRIVILEGES;
exit;
退出,再重新登录 设置远程登录
设置本机被远程连接
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;