----Linux安装MySQL----
----查看是否安装MySQL
rpm -qa | grep mysql
----查看是否有MySQL用户----
groups mysql
----下载官方包----
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
----安装包----
yum -y install mysql57-community-release-el7-10.noarch.rpm
----安装mysql----
yum -y install mysql-community-server
----报错公匙未安装----
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
----报错Unable to find a match: mysql-community-server----
yum module disable mysql
----重新安装MySQL----
yum -y install mysql-community-server
----启动MySQL----
systemctl start mysqld.service
----执行报错,先给予权限重试----
chown mysql:mysql -R /var/lib/mysql
----查看MySQL运行状态----
service mysqld status
----查看初始密码----
grep 'password' /var/log/mysqld.log
----登录MySQL----
mysql -u root -p
----输入密码后登录,修改初始密码----
ALTER USER 'root'@undefined
----添加远程连接用户----
create user 'Ylfs@undefined
----给予用户Ylfs@1权限----
grant all on *.* to 'Ylfs@undefined
----创建库----
CREATE DATABASE PRODUCT;
- 复制链接
- 举报
点赞
领取本源代码、数据库