配置数据库
查看自己得数据库版本
yum list installed | grep mysql
Expected output:
mysql-libs.x86_64 5.1.73-5.el6_6
@anaconda-CentOS-201508042137.x86_64/6.7
删除自己得老版本数据库
yum remove mysql*
添加新得数据库下载
rpm -ivh http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
Expected output:
Retrieving http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpmPreparing…
##################################### [100%] 1:mysql-community-release
[100%]
安装数据库和vim编译器
yum install mysql-server vim -y
配置my.cnf文件
vim /etc/my.cnf
[mysqld]
innodb_file_per_table
启动数据库
service mysqld start
设置密码
/usr/bin/mysql -u root mysql
注意:mysql与mysql_safe目录一样,都是:/usr/bin/下,这个是通过“ps -ef | grep -i mysql”命令得到的。
出现“mysql>”提示符后输入:
mysql> update user set password = Password('root') where User = 'root';
回车后执行(刷新MySQL系统权限相关的表):
mysql> flush privileges;
再执行exit退出:
mysql> exit;
允许远程登录:
mysql -u root -p"youpassword"
进行授权操作:
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
重载授权表:
FLUSH PRIVILEGES;
退出mysql数据库:
exit