linux安装mysql80
打开网址:https://dev.mysql.com/downloads/repo/yum/,选择对应li
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
安装mysql源
yum -y localinstall mysql80-community-release-el7-3.noarch.rpm
查看是否安装成功:
cd /etc/yum.repos.d/
查看mysql相关资源
使用命令:yum repolist all | grep mysql,查看当前yum repolist的所有版本
这里一般不需要改,根据自己需要就好 看这个设置enabled有没有是true,没有的话就改一下 切换版本 [root@localhost ~] sudo yum-config-manager --enable mysql80-community [root@iZm5e3d7te8727xoyd0vhdZ yum.repos.d]# sudo yum-config-manager --enable mysql80-community Loaded plugins: fastestmirror ============================================================================================ repo: mysql80-community ============================================================================================ [mysql80-community] async = True bandwidth = 0 base_persistdir = /var/lib/yum/repos/x86_64/7 baseurl = http://repo.mysql.com/yum/mysql-8.0-community/el/7/x86_64 cache = 0 cachedir = /var/cache/yum/x86_64/7/mysql80-community check_config_file_age = True compare_providers_priority = 80 cost = 1000 deltarpm_metadata_percentage = 100 deltarpm_percentage = enabled = True enablegroups = True exclude = failovermethod = priority ftp_disable_epsv = False gpgcadir = /var/lib/yum/repos/x86_64/7/mysql80-community/gpgcadir gpgcakey = gpgcheck = True gpgdir = /var/lib/yum/repos/x86_64/7/mysql80-community/gpgdir gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022, file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql hdrdir = /var/cache/yum/x86_64/7/mysql80-community/headers http_caching = all includepkgs = ip_resolve = keepalive = True keepcache = False mddownloadpolicy = sqlite mdpolicy = group:small mediaid = metadata_expire = 21600 metadata_expire_filter = read-only:present metalink = minrate = 0 mirrorlist = mirrorlist_expire = 86400 name = MySQL 8.0 Community Server old_base_cache_dir = password = persistdir = /var/lib/yum/repos/x86_64/7/mysql80-community pkgdir = /var/cache/yum/x86_64/7/mysql80-community/packages proxy = False proxy_dict = proxy_password = proxy_username = repo_gpgcheck = False retries = 10 skip_if_unavailable = False ssl_check_cert_permissions = True sslcacert = sslclientcert = sslclientkey = sslverify = True throttle = 0 timeout = 30.0 ui_id = mysql80-community/x86_64 ui_repoid_vars = releasever, basearch username =
安装mysql-community-server
yum -y install mysql-community-server,下载的东西比较多要稍微等会
启动:
systemctl start mysqld.service
查看运行状态图;
systemctl status mysqld.service
此时MySQL已经开始正常运行,不过要想进入MySQL还得先找出此时root用户的密码,通过如下命令可以在日志文件中找出密码:
grep "password" /var/log/mysqld.log
kr>butC(c8)l
ALTER USER 'root'@'localhost' IDENTIFIED BY '**********';

密码设置规则;
这是网上案例:可以修改密码策略和长度我的是mysql80策略长度都可以所以没执行这两条平命令
set global validate_password.policy=0;弱密码
character_set_server=utf8
init_connect='SET NAMES utf8':
最后用navicat登录数据库报如下错误:
1130-host ... is not allowed to connect to this MySql server
出现此问题的原因是mysql对root的权限做了限定,host必须是localhost
可以用如下方法修改host为‘%’即可。
use mysql;
update user set host = '%' where user ='root';
Navictat密码和数据库默认的数据库密码类型不一致出现的问题
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '****';
Flush privileges;
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '********'
mysql -uroot -p
mysql> grant all privileges on *.* to 'root'@'%' with grant option;
ERROR 1410 (42000): You are not allowed to create a user with GRANT
update user set host='%' where user='root';
》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》》
一、 Linux启动/停止/重启Mysql数据库的方法
1、查看mysql版本
方法一:status;
方法二:select version();
2、Mysql启动、停止、重启常用命令
a、启动方式
1、使用 service 启动:
二、 systemctl stop mysqld.service(8.0)
[root@localhost /]# service mysqld start (5.0版本是mysqld)
[root@szxdb etc]# service mysql start (5.5.7版本是mysql)
2、使用 mysqld 脚本启动:
/etc/inint.d/mysqld start
3、使用 safe_mysqld 启动:
safe_mysqld&
b、停止
1、使用 service 启动:
service mysqld stop
2、使用 mysqld 脚本启动:
/etc/inint.d/mysqld stop
3、mysqladmin shutdown
c、重启
1、使用 service 启动:
service mysqld restart
service mysql restart (5.5.7版本命令)
2、使用 mysqld 脚本启动:
/etc/init.d/mysqld restart
二、连接MySQL:
格式: mysql -h主机地址 -u用户名 -p用户密码
1、例1:连接到本机上的MYSQL
找到mysql的安装目录,一般可以直接键入命令mysql
-uroot -p,回车后提示你输密码,如果刚安装好MYSQL,超级用户root是没有密码的,故直接回车即可进入到MYSQL中了,MYSQL的提示符是:mysql>
2、连接到远程主机上的MySQL
假设远程主机的IP为:10.0.0.1,用户名为root,密码为123。则键入以下命令:
mysql -h10.0.0.1 -uroot -p123
(注:u与root可以不用加空格,其它也一样)
3、退出MySQL命令
exit (回车)
本文来自博客园,作者:余生请多指教ANT,转载请注明原文链接:https://www.cnblogs.com/wangbiaohistory/p/14106884.html