13.Linux下安装Mysql
1.下载安装cd /homewget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpmrpm -ivh mysql-community-release-el7-5.noarch.rpmyum install mysql-community-server过程中多次提示Is this ok [y/N],输入y,回车即可2
·
1.下载安装
cd /home
wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-community-server
过程中多次提示Is this ok [y/N],输入y,回车即可
2.启动
service mysqld start
3.配置
(1).账户
mysql -u root
//设置密码
mysql> set password for 'root'@'localhost' =password('密码');
//赋值权限
mysql> grant all privileges on *.* to root@'%'identified by '密码';
//刷新生效
mysql> flush privileges;
(2).编码
vim /etc/my.cnf
default-character-set = utf8
4.非安装后修改密码
(1).修改my.cnf
vim /etc/my.cnf
在[mysqld]最后一行加上skip-grant-tables
(2).重启mysql
service mysqld restart
(3).登录mysql后修改密码
mysql -u root
update mysql.user set authentication_string=PASSWORD('admin123') where User='root';
flush privileges;
(4).改回my.cnf,重启mysql
更多推荐
所有评论(0)