Shulou(Shulou.com)06/01 Report--

1, Check CentOS comes with MySQL 5.1 components and uninstall

rpm -qa | grep -i mysql

rpm -e --nodeps mysql-libs-5.1.61-4.el6.x86_64

2、rpm -ivh numactl-2.0.9-2.el6.x86_64.rpm

rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm

3、rpm -ivh mysql-community-common-5.7.18-1.el6.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.18-1.el6.x86_64.rpm

rpm -ivh mysql-community-client-5.7.18-1.el6.x86_64.rpm

rpm -ivh mysql-community-server-5.7.18-1.el6.x86_64.rpm

4. Modify database encoding.

To ensure that the database can process Chinese correctly, we need to set the default encoding of the database to utf8. Modify the/etc/my.cnf file and add the following:

[client]

default-character-set=utf8mb4

[mysqld]

character_set_server=utf8mb4

5. Change the time zone

Start MySQL

service mysqld start

6. mysql login and password modification

mysql -u root -p

7. In CentOS, the firewall blocks port 3306 by default. Now port 3306 is open.

Modify the/etc/sysconfig/iptables file to add the following:

Query firewall status:

[root@localhost ~]# service iptables status

Stop Firewall:

[root@localhost ~]# service iptables stop

Start firewall:

[root@localhost ~]# service iptables start

Restart firewall:

[root@localhost ~]# service iptables restart

Permanently turn off firewall:

[root@localhost ~]# chkconfig iptables off

Enable after permanent shutdown:

[root@localhost ~]# chkconfig iptables on

Restart firewall:

1)Permanently effective after restart:

Open: chkconfig iptables on

Close: chkconfig iptables off

2)Effective immediately, invalid after restart:

Open: service iptables start

Close: service iptables stop It should be noted that for other services under Linux, you can use the above command to perform opening and closing operations.

-------------

Fatal error: mysql.user table is damaged. Please run mysql_upgrade.

1、rm -rf /var/lib/mysql/

Use the following command to reinitialize mysql

mysqld --initialize --user=mysql

3、service mysqld start

-------------

Change root password error resolution:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) : Indicates that no temporary password for root was generated

1, service mysql stop Stop mysql server

2、mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

3、show databases;

use mysql;

show tables;

4、update user set authentication_string=PASSWORD('root123!@# ') where user='root';

flush privileges;

exit;

-------------

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

1、SET PASSWORD = PASSWORD('root123!@# ');

2、flush privileges;

3、exit;

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.