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

The following is followed by the author to understand the preliminary knowledge of mysql, I believe everyone will benefit a lot after reading, the text is not in the essence, I hope that the preliminary knowledge of mysql to understand this short content is what you want.

1. Mysql > SET PASSWORD FOR 'username'@'host'=PASSWD (' 123456')

Mysql > FLUSH PRIVILEGES; / / reread the authorization table

2. Mysql > UPDATE mysql SET password=' 'WHERE user='root' AND host=''

3. # mysqladmin-u root-h host-p password' password'

Graphics client of mysql

1 、 phpMyAdmin

2 、 Workbench

3 、 Toad

Mysql driver for php53-mysql:php.

Php Forum

1 、 discuz

2 、 phpwind

3 、 phpbb

CMS

Drupal

Joomla

Wordpress

After reading the preliminary knowledge of mysql to understand this article, many readers will certainly want to know more about it. If you need more industry information, you can follow our industry information section.

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.