大佬教程收集整理的这篇文章主要介绍了CentOS 6.5 二进制安装MySQL 5.6,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
CentOS 6.5 二进制安装MysqL 5.6
--------------------------------
下载MysqL5.6二进制包
mysql-5.6.20-linux-glibc2.5-x86_64.tar.gz
安装相关依赖包
yum install libaio*
useradd MysqL
tar zxvf mysql-5.6.20-linux-glibc2.5-x86_64.tar.gz -C /data/
@H_297_14@mv mysql-5.6.20-linux-glibc2.5-x86_64 MysqL修改MysqL的各级文件夹和文件的创建者、创建组为MysqL(注意语句后面有个.)
chown -R MysqL.MysqL /data/MysqL
至此MysqL已经安装完了,
但还需要初始化,初始化MysqL表、test表、infomation表等。
/data/MysqL/scripts/MysqL_install_db --datadir=/data/MysqL/data --basedir=/data/MysqL --user=MysqL --explicit_defaults_for_timestamp
-------------------------------------------------------------------------------------------------------------------------------------
拷贝启动脚本
cp /data/MysqL/support-files/MysqL.server /etc/init.d/MysqLd
ln -s /data/MysqL/include /usr/include/MysqL
echo "/data/MysqL/lib" > /etc/ld.so.conf.d/MysqL.conf && ldconfig -v
ln -s /data/MysqL/bin/MysqL /usr/bin
cd /data/MysqL
cp my.cnf /etc/my.cnf
vim /etc/my.cnf
basedir = /data/MysqL
datadir = /data/MysqL/data
port = 3306
server_id = 1
-------------------------
启动MysqL服务
MysqL> SELECT user,host,password FROM MysqL.user;
+------+-----------------------+----------+
| user | host | password |
+------+-----------------------+----------+
| root | localhost | |
| root | localhost.localdomain | |
| root | 127.0.0.1 | |
| root | ::1 | |
| | localhost | |
| | localhost.localdomain | |
+------+-----------------------+----------+
6 rows in set (0.00 seC)
设置密码()括号里面的为密码,用户名root
MysqL> updatE MysqL.user set password = passworD('Zykj@password') WHERE user = 'root';
MysqL> SELECT user,password FROM MysqL.user;
+------+-----------------------+-------------------------------------------+
| user | host | password |
+------+-----------------------+-------------------------------------------+
| root | localhost | *11B9ACA21786F766739D0EB1483C5F64212B81AC |
| root | localhost.localdomain | *11B9ACA21786F766739D0EB1483C5F64212B81AC |
| root | 127.0.0.1 | *11B9ACA21786F766739D0EB1483C5F64212B81AC |
| root | ::1 | *11B9ACA21786F766739D0EB1483C5F64212B81AC |
| | localhost | |
| | localhost.localdomain | |
+------+-----------------------+-------------------------------------------+
6 rows in set (0.00 seC)
MysqL> DROP USER ''@localhost;
MysqL> FLUSH PRIVILEGES;
MysqL> quit
---------------------MysqL安装完成-------------------------------
设置/修改 密码
MysqL> grant all privileges on *.* to 'root'@'localhost' identified by 'Zykj@password' with grant option;
MysqL> flush privileges;
以上是大佬教程为你收集整理的CentOS 6.5 二进制安装MySQL 5.6全部内容,希望文章能够帮你解决CentOS 6.5 二进制安装MySQL 5.6所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。