安装mysql
centos7 安装mysql
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
centos8 安装mysql
yum install mysql-server
安装之后重启mysql服务
service mysqld restart
初次安装mysql是root账户是没有密码的
设置密码的方法
mysql -uroot
mysql> set password for ‘root’@‘localhost’ = password('mypasswd');
mysql> exit
查询mysql 初始密码
su grep 'temporary password' /var/log/mysqld.log
重置mysql 密码
停止mysql 服务
/etc/init.d/mysqld stop
/etc/init.d/mysql stop
输入绕过密码认证命令
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
登录后修改密码即可
创建用户
create user 'onewuqi'@'%' identified with mysql_native_password by 'onewuqi@123456';
create user 'onewuqi'@'%' identified by 'onewuqi@123456';
创建了用户名为onewuqi,密码为onewuqi@123456的用户,如果需要用navicat连接,则使用老的加密方式mysql_native_password,如果是8.0以前的数据库,可以不加。
授权远程登录
grant all on *.* to 'imooc'@'%';
flush privileges;