method to retrieve MARIADB database root user rights in CentOS _MARIADB

A few days ago on the Internet, see an article, said MySQL from being orcle revenue bag, have abandoned the meaning of the MySQL community Open source, and the MySQL into the community and Enterprise version. I day his ancestors board, are Money TM trouble. The founder of the MySQL other men, create MARIADB, It is rumored that its second daughter name. A hand splash, on the CentOS waste MySQL Li mariadb.

Yesterday's rest, nothing to do, at night even more, coupled with hot days, sleepless nights. The boot into the CentOS, check the day before the Mariadb,root unexpectedly without password, is password. However, in the user table, the root of the list has five, so only a host for%, All of them are deleted. After feeling improperly, to host=localhost to make up. When I feel very happy, I do not know the catastrophe to the.

To be out, the Mariadb,mysql library unexpectedly hidden. Google under the search, was the result of this machine login, the original user table to root for the artifact, the rest of the Chen. Host for localhost, lost its right, so MySQL is not present.

The desire to abolish the new, but Google has tasted this law, can not solve. The Niang returns to the MySQL to skip-grant-tables the method or to be able to solve. Try, lose. MARIADB, although with the same branch of MySQL, is not completely the same, can not be solved.

Think for a long, so with-------------------127.0.0.1 try, but the harvest is quite abundant. To this, the site of this machine, to 127.0.0.1,localhost for the rope. Think of the CentOS to the location of the rope, change IP, try it.

The right to take charge of the localhost. Back into, MySQL is now. This is a difficult solution.

PS: A generation of Master Ye Yun: Never forget, there must be echoes. Sincerity does not deceive me also.