Connect a database of Zen trails deployed in XAMPP integrated environments under Linux MARIADB

Use the MySQL database tool to connect to the LINUXMYSQL environment, but you will encounter problems with connection failures, as follows:

This needs to involve another problem, we need to open MySQL connection authorization, the specific steps are as follows:

1) in the Xshell into MySQL, the command is: Mysql-u root-p, and then enter into the MySQL.

The following is an error condition

[Email protected] opt]# mysql-u root-p
Enter Password:
ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)

Don't panic, mariadb the command to enter the database is as follows; PS: As for the '/var/lib/mysql/mysql.sock ' (2) Error problem see following share content)

[Email protected] opt]# mysql-h 127.0.0.1
Welcome to the MariaDB Monitor. Commands End With; or \g.
Your MariaDB Connection ID is 244
Server version:10.1.19-mariadb Source Distribution

Copyright (c) Monty, Oracle, program Ab and others.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

2) then enter the command: Use MySQL, switch to the MySQL database as follows:

MariaDB [(none)]> use MySQL
Reading table information for completion of table and column names
Can turn off this feature to get a quicker startup with-a

Database changed

You can then view the MySQL you are using (PS: After this step, you can refer to the

MySQL database link and create)

Then you can create a username password.

That way, the database account is created.

The account password is also available.

Then you can link it with Navicat.

Connect a database of Zen trails deployed in XAMPP integrated environments under Linux MARIADB