飞龙博客

feilong.org 前端开发教程

edit phpmyadmin password creat database or add new user

飞龙修订于 20050125 04:19 56 次浏览

In order to install php website,you should have a database username and password.Feilong want to creat a new database and user usually through phpmyadmin on cpanel or wamp.But how to use phpmyadmin?here is an example feilong use wamp(refer to http://feilong.org/wamp-setup-en ) on localhost,this post updated on March 25 2010 by feilong,url is http://feilong.org/phpmyadmin-database-user-en

One,how to edit the password of  phpmyadmin?

1.Enter phpmyadmin first of course.
2.click "databases"
3.click"privileges"
4.The line where user is root and host is localhost?Click the pencil button.
5."Change password",input your new password,then "GO".If you refresh the webpage,you can notice that phpmyadmin warining appears!
6.Open “wamp\apps\phpmyadmin 2.11.6\config.inc.php"
7.CTRL+F,find"MySQL password (only needed)",edit the password(on left) to the password you have changed just now.
8.refresh phpmyadmin.ok?

Two,how to creat database on phpmyadmin?

1.Click"databases"
2."Create new database "

Three,how to bundle database and user together?That is,phpmyadmin Database-specific privileges

1.Click"privileges"
2.Click"Add a new User ",then "Login Information",input user name"feilong" host"localhost"and password"******"
3.Next"Global privileges",data choose all but file,Structure choose all but drop,Administration choose "grant"and"lock tables".Then "GO"
4.Next"Database-specific privileges" "Add privileges on the following database",choose the database you creat before.Then "Database-specific privileges",click "Check All"and "GO"
5.Click"privileges",ok,you have bundled a database and a user together!

Four,some feilong tips
1.how to install mediawiki on wamp,http://feilong.org/mediawiki-install-en
2.how to install wordpress mu on wamp localdomain,http://feilong.org/install-wordpress-mu-wamp-localdomain
3.how to setup wamp http://feilong.org/wamp-setup-en
4.The Chinese editon of this post,http://feilong.org/wamp-setup
5.if you dont like wamp,you can choose xampp instead,http://feilong.org/xampp-setup-en

网址:https://feilong.org/phpmyadmin-database-user-en
初发:20050125 04:19

想学前端?长按二维码加我微信

想学前端?点击飞龙QQ

分类: 默认

新作:

旧文:

关闭

长按二维码 -> 识别图中二维码

打开微信,发现,扫一扫

支付完成后,点击下一步

感谢大力支持

然后你手机号:

最后点这,稍等即可