腾讯云centos7 搭建mysql
参考地址:
https://blog.csdn.net/paulowina/article/details/79890644?utm_source=copy
1.检查环境
安装前检查是否安装过mysql
yum list installed mysql*
如果有就用yum remove卸载mysql
2.1.官方yum源安装
(1)进入本机的源文件目录
cd /usr/local/src
(2)使用wget下载官方yum源的rpm包
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
(3)安装mysql源
yum localinstall mysql57-community-release-el7-11.noarch.rpm
(4)检查mysql源是否安装成功
yum repolist enabled | grep "mysql.*-community.*"
2.2 安装mysql
(1)安装mysql
yum install mysql-community-server
(2)启动mysql服务
systemctl start mysqld
(3)检查mysql启动状态
systemctl status mysqld
或
ps aux|grep mysqld
(6)开机启动
systemctl enable mysqld
systemctl daemon-reload
3.登录mysql
因为在安装mysql时,系统会自动分配一个root账户给你,当时密码是默认的
grep 'temporary password' /var/log/mysqld.log 或 cat /var/log/mysqld.log|grep 'A temporary password' 查看默认密码
localhost就是root账户的默认密码
进入mysql:mysql -uroot -p
4.修改root默认密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
5 配置mysql默认编码为utf8
:virm /usr/my.ini
查看数据库的编码方式命令为
show variables like 'character%';
修改编码格式:
1 2 3 |
|
mysql一些常用命令(注意:在mysql目录下,所有的命令结束之后必须加;)
重启mysql服务:/bin/systemctl restart mysqld.service
查询mysql服务状态:正确命令:/bin/systemctl status mysqld.service
修改密码:ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
set password for 'root'@'localhost'=password('MyNewPass4!');
展示所有的数据库:show databases;
展示所有的表格:show tables;
退出数据库
命令行:quit;