关于配色的网站,主流网站建设服务器有哪些,企业网站php源码免费下载,平面设计要什么学历1.mysql-5.7.25-1.el6.x86_64.rpm-bundle.tar下载百度云资源提取码#xff1a;ej1y2.把下载的mysql安装包上传到Centos上解压mysql#xff0c;我这是在Windows上解压的上传到Centos上#xff0c;我在Centos上解压mysql不知道为什么少了rpm -ivh mysql-community-common-5.7.…1.mysql-5.7.25-1.el6.x86_64.rpm-bundle.tar下载百度云资源提取码ej1y2.把下载的mysql安装包上传到Centos上解压mysql我这是在Windows上解压的上传到Centos上我在Centos上解压mysql不知道为什么少了rpm -ivh mysql-community-common-5.7.25-1.el6.x86_64.rpm包tar –xvf mysql-5.7.25-1.el6.x86_64.rpm-bundle.tar3.查看mysql依赖rpm -qa | grep mysql4.如果查看有mysql依赖就删除mysql依赖,rpm -e --nodeps rpm -qa | grep mysql5.再次查是否有mysql依赖rpm -qa | grep mysql6.安装一定要按照顺序来第一个安装 rpm -ivh mysql-community-common-5.7.25-1.el6.x86_64.rpm报了一个错误[rootlocalhost mysql-5.7.25]# rpm -ivh mysql-community-common-5.7.25-1.el6.x86_64.rpmwarning: mysql-community-common-5.7.25-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYPreparing... ########################################### [100%]file /usr/share/mysql/charsets/Index.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/armscii8.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/ascii.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/cp1250.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/cp1251.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/cp1256.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/cp1257.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/cp850.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/cp852.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/cp866.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/dec8.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/geostd8.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/greek.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/hebrew.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/hp8.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/keybcs2.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/koi8r.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/koi8u.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/latin1.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/latin2.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/latin5.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/latin7.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/macce.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/macroman.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64file /usr/share/mysql/charsets/swe7.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64[rootlocalhost mysql-5.7.25]# file /usr/share/mysql/charsets/Index.xml from install of mysql-community-common-5.7.25-1.el6.x86_64 conflicts with file from package MariaDB-common-10.4.8-1.el7.centos.x86_64/usr/share/mysql/charsets/Index.xml: XML document textfrom: cannot open from (No such file or directory)install: cannot open install (No such file or directory)of: cannot open of (No such file or directory)mysql-community-common-5.7.25-1.el6.x86_64: cannot open mysql-community-common-5.7.25-1.el6.x86_64 (No such file or directory)conflicts: cannot open conflicts (No such file or directory)with: cannot open with (No such file or directory)file: cannot open file (No such file or directory)from: cannot open from (No such file or directory)package: cannot open package (No such file or directory)MariaDB-common-10.4.8-1.el7.centos.x86_64: cannot open MariaDB-common-10.4.8-1.el7.centos.x86_64 (No such file or directory)原因已存在MariaDB-common-10.4.8-1.el7.centos.x86_64的库(这是我以前安装MariaDB数据库如果是别的也要根据对应的名字删除)所以需要先删除以前的库才能安装执行强制卸载命令rpm -e MariaDB-common-10.4.8-1.el7.centos.x86_64--nodeps然后查看rpm –qa | grep mysql再继续安装rpm -ivh mysql-community-common-5.7.25-1.el6.x86_64.rpm[rootlocalhost mysql-5.7.25]# rpm -ivh mysql-community-common-5.7.25-1.el6.x86_64.rpmwarning: mysql-community-common-5.7.25-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYPreparing... ########################################### [100%]1:mysql-community-common ########################################### [100%]第二个安装rpm -ivh mysql-community-libs-5.7.25-1.el6.x86_64.rpm[rootlocalhost mysql-5.7.25]# rpm -ivh mysql-community-libs-5.7.25-1.el6.x86_64.rpmwarning: mysql-community-libs-5.7.25-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYPreparing... ########################################### [100%]1:mysql-community-libs ########################################### [100%]第三个安装rpm -ivh mysql-community-client-5.7.25-1.el6.x86_64.rpm[rootlocalhost mysql-5.7.25]# rpm -ivh mysql-community-client-5.7.25-1.el6.x86_64.rpmwarning: mysql-community-client-5.7.25-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYPreparing... ########################################### [100%]1:mysql-community-client ########################################### [100%]第四个安装rpm -ivh mysql-community-server-5.7.25-1.el6.x86_64.rpm[rootlocalhost mysql-5.7.25]# rpm -ivh mysql-community-server-5.7.25-1.el6.x86_64.rpmwarning: mysql-community-server-5.7.25-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYPreparing... ########################################### [100%]1:mysql-community-server ########################################### [100%]You have new mail in /var/spool/mail/root第五个安装rpm -ivh mysql-community-devel-5.7.25-1.el6.x86_64.rpm[rootlocalhost mysql-5.7.25]# rpm -ivh mysql-community-devel-5.7.25-1.el6.x86_64.rpmwarning: mysql-community-devel-5.7.25-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYPreparing... ########################################### [100%]1:mysql-community-devel ########################################### [100%]7.使用命令启动mysql服务service mysqld start[rootlocalhost mysql-5.7.25]# service mysqld startStarting mysqld: [ OK ][rootlocalhost mysql-5.7.25]#8.使用命令生成一个随机密码grep temporary password /var/log/mysqld.log[rootlocalhost mysql-5.7.25]# grep temporary password /var/log/mysqld.log2020-04-07T12:32:39.276158Z 1 [Note] A temporary password is generated for rootlocalhost: vuyo:fg7.O[rootlocalhost mysql-5.7.25]#注意密码是rootlocalhost:右边的字符串rootlocalhost: vuyo:fg7.O 这里生成的随机密码是vuyo:fg7.OMySQL 会在 /var/log/mysqld.log 日志中生成一个随机密码默认需要修改密码才能使用可以通过 vim /var/log/mysqld.log 打开里面有一行这样的代码2020-04-07T12:32:39.276158Z 1 [Note] A temporary password is generated for rootlocalhost: vuyo:fg7.O9.修改密码先登录mysqlmysql -u root –p[rootlocalhost mysql-5.7.25]# mysql -u root -pEnter password:我这随机密码就是vuyo:fg7.O10.登录成功[rootlocalhost log]# mysql -u root -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 12Server version: 5.7.25Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type help; or \h for help. Type \c to clear the current input statement.mysql ALTER USER rootlocalhost IDENTIFIED BY wangqing;Query OK, 0 rows affected (0.01 sec)mysql11.修改密码mysql ALTER USER rootlocalhost IDENTIFIED BY 新密码;12.设置权限为了可以远程连接该数据库需要设置相应的权限#任何主机mysqlGRANT ALL PRIVILEGES ON *.* TO root% IDENTIFIED BY 刚刚修改的密码 WITH GRANT OPTION;#指定主机mysqlGRANT ALL PRIVILEGES ON *.* TO xxxx’xx.xx.xx.xx’ IDENTIFIED BY xxxx WITH GRANT OPTION;13.刷新权限mysqlflush privileges;这就完成了可以用sql工具连接mysql了
