MySQL initialization configuration and command line options

To find the order and parameters of the configuration file:

/usr/bin/mysql--help--verborse View:

Default options is read from the following files in the given order:/etc/mysql/my.cnf/etc/my.cnf ~/.my.cnf

Set Password:

Start service: Systemctl start mariadb

Connection server: MySQL

Select MySQL table: use MySQL;

Delete no user entries:

Drop user ' @ ' localhost ';

Drop user ' @ ' www.centos.pig ';

Set Password: Update user set Passeord=password (' Your_password ') where user= ' root ';

Let the server reread: Flush privileges;

MySQL initialization configuration and command line options