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

Recently, because of the need to use mysql, and then set up some problems according to the environment of the old boy's "learning linux operation and maintenance from the old boy-web cluster practice" to learn mysql. In the initial study, it is recommended that you install step by step according to the content (after all, you may not know what it means at the beginning). As a result, I struggled with a problem for a long time-when I first logged in to mysql, I suddenly found that I had to enter my password, but I didn't set a password, and then entered all the passwords I used (after all, the server didn't do anything, all kinds of login passwords were the same) and found that I still couldn't log in. Finally, in a variety of Baidu online, finally found: after the original mysql5.5 (or 5.7), the default password is no longer empty, but there will be a randomly generated initial password. The password is in the following path / var/log/mysqld.log (remember not to use / root/.mysql_secret, useless). Use grep password-n / var/log/mysqld.log to find something like this: 9 18T06:40:17.259575Z 2017-05-18T06:40:17.259575Z 1 [Note] A temporary password is generated for root@localhost: lu=uN2rGegBC use this login to OK, and then set your own password.

Change the password: change the password rules first. There are three levels 0, 1, 2 by default. Level 0 only card length, 1 will card length and character situation. So in order to make the password less complex, change the password rule to 0. (the default is 1).

Set global validate_password_policy=0

Set password: set password=password ('redhat123')

So you can log in. Show databases can see if it was successful. The password should be remembered at this time.

How to log in to mysql database remotely in the form of ip+ port number?

First log in to the database at the shell terminal, and then execute the following statement GRANT ALL PRIVILEGES ON *. * TO 'itoffice'@'%' IDENTIFIED BY' itoffice' WITH GRANT OPTION;. You need flush privileges to take effect. At this point, you can log in directly in the form of an IP+ port number.

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.