mysql官网rpm包安装以及初次设置

如果报文件冲突：file /usr/share/mysql/charsets/swe7.xml from install of mysql-community-common-5.7.18-1.el7.x86_ conflicts with file from package mariadb-libs-1:5.5.44-2.el7.centos.x86_

解决办法：

执行以下命令，删除mariadb-libs-1:5.5.44： yum -y remove mariadb-libs-1:5.5.44* 再执行以下命令安装MySQL：

rpm -ivh mysql-community-libs-5.7.18-1.el7.x86_.rpm rpm -ivh mysql-community-client-5.7.18-1.el7.x86_.rpm rpm -ivh mysql-community-server-5.7.18-1.el7.x86_.rpm

/etc/my.cnf Directory /usr/bin /usr/sbin /var/lib/mysql Contents of Directory Client programs and scripts The mysqld server Log files, databases MySQL manual in Info format Unix manual pages Include (header) files Libraries Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation /var/lib/mysql-files Value of secure_file_priv /usr/share/info /usr/share/man /usr/include/mysql /usr/lib/mysql /usr/share/mysql /usr/share/sql-bench Benchmarks

启动mysql

systemctl enable mysqld //设置开机自启动 systemctl start mysqld

尝试进入mysql mysql -uroot -p 密码为空

systemctl start mysqld.service centos 7系统：

mysqld --user=mysql --skip-grant-tables --skip-networking & mysql

Mysql5.6（含）执行下面的语句没错

mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';

但是Mysql5.7中password字段变为了authentication_string，所以语句如下：

mysql> update mysql.user set authentication_string=password('root123') where user='root' mysql> flush privileges; mysql> quit

此时,mysql -uroot -p已经可以让你进去mysql了，之后还要再次修改一次密码，才可使用查表等语句:

mysql>SET PASSWORD = PASSWORD('root123')