 | Forum | Register | Search | Today's Posts | Mark Forums Read |  |
|
|
 |
|
| ||||||
|
Welcome to the The ProgrammersTalk Community forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
 |
 | | LinkBack | Thread Tools | Display Modes |  |
06-10-2007, 07:35 PM
| |||
| |||
| How To Set The MYSQL Root Password Many people ask how to set the MySQL root password. Its not as easy as it sounds. On windows, find the mysql console in the start menu (you do not have this aplication if you are using XAMP!) or in linux type mysql at the bash prompt then type the following (it puts the mysql> prompt there for you) Code:
mysql> -u root
mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD('new-password') WHERE user='root';
mysql> FLUSH PRIVILEGES; __________________           |
| |
|
06-19-2007, 02:42 PM
| ||||
| ||||
| Cool, but I'm still wondering to why are you suppose to flush the priviledges? Can you please elaborate more to that line? thx a lot  rep added__________________ |
|
06-19-2007, 10:29 PM
| ||||
| ||||
| Quote:
 haha... well, at least usually I don't use those to change my mySQL password **is that how you say it..??** lol..__________________ |
|
| Thread Tools | |
| Display Modes | |
| |
Linear Mode
