dbForge Studio for MySQLĭbForge Studio for MySQL is one of the most robust tools for database developers and administrators. In this guide, we will share a list of the best MySQL graphical user interface (GUI) tools for Linux systems. It is an advanced, fast, reliable, scalable, and easy-to-use RDBMS intended for mission-critical, heavy-load production systems and packaged software. To set a simple password, only modify the password policy again and reset the password to 123456 ALTER USER IDENTIFIED WITH mysql_native_password BY '123456' Įverything is ready and the connection is successful.MySQL is one of the most widely-used open-source relational database management systems ( RDBMS), that has been around for a long time. Run the following command to change the localhost of the host to %, and refresh the configuration update user set host = '%' where user ='root' Īfter connecting again, the following error will be reported, which is caused by the modification operation in the previous step. Therefore, we need to set up the mysql server to allow you to connect. The reason for the error is: the mysql server does not allow your program to access its database.

Modify the password length requirement to 6 set global validate_password.length=6 Īfter the modification is completed, the password can be set to 123456.ĭirect connection like this will report an error, xxx is not allowed to connect to this mysql server. Modification level is low set global validate_password_policy=LOW show variables like 'validate_password%' You need to set a complex password first, otherwise the subsequent operations cannot be performed. Three, modify the password policyįriends who like complex passwords can skip this section. It can be solved by setting a complex password or modifying the policy.Īfter changing the password, mysql can be used. The password is too simple to meet the current security policy. Use the following command to modify the password in mysql ALTER USER IDENTIFIED WITH mysql_native_password BY '123456' Use the initial password to log in to the databaseĪt this time, the database cannot be used normally, mysql needs to change the password before it can be used. View the initialization password in the mysql log cat /var/log/mysqld.log You need a password to log in after mysql is installed. There are many tutorials on this installation on the Internet, but many are not easy to use because of the version and other reasons, so go directly to the official website to have a look.Įnter the installation command rpm -Uvh CentOS7 install mysql and connect with Navicat

Install navicat on ubuntu