Debian9 installing MySQL MARIADB

Debian9 MySQL replaced by mariadb-server-10.1

But they are similar.

"MySQL and mariadb differences"

http://ask.chinaunix.net/question/556

After the father of MySQL Widenius left Sun, he felt that relying on sun/oracle to develop MySQL is very unreliable, so decided to open another branch, the name of this branch is called MARIADB.

。。。。。

So for the majority of MySQL users, from the current mainstream MySQL to MARIADB should be no difficulty

1 su switch to root account

Apt-get Install Mysql-server

Shown below (Prompt to run the installation command again after installation is complete)

# apt-get Install MySQL
Reading Package Lists ... Done
Building Dependency Tree
Reading state information ... Done

MySQL is the Debian mariadb installation success

2 Turn on server Remote ping Server IP discovery can ping

But cannot log in mariadb this is because remote access is not turned on

The default path/ETC/MYSQL/MARIADB.CONF.D open 50-server.cnf

Will

# Instead of skip-networking The default is now-listen only on
# localhost which are more compatible and are not less secure.
bind-address= 127.0.0.1

Revision changed to

# Instead of skip-networking The default is now-listen only on
# localhost which are more compatible and are not less secure.
#bind-address= 127.0.0.1

Save the document server with root privileges to identify connections other than 127.0.0.1

3 Enter the server to open remote account access

Under MySQL, enter grant all privileges on *. * to ' root ' @ '% ' identified by ' Rootpassword ' with GRANT option;

Open the account for the remote Access database.

4 Remote Access Yes, I'm using Navicat.

Follow the prompts to set the connection properties

Debian9 installing MySQL mariadb