how to set password for MySQL
Posted by: Bao (---.reshsg.uci.edu)
Date: January 24, 2007 11:46AM

Hey everyone,

I just downloaded WAMP and I am amazed at how easy it was to install, now there is a message at the bottom of my phpMyAdmin page urging me to set a password for my MySQL for security reaons, does anyone have any idea how to set a password for MySQL? I am sure it is a very simple process but I am kinda new to the MySQL PHP community and do not really know where to start.

Options: ReplyQuote
Re: how to set password for MySQL
Posted by: yfastud (---.cable.mindspring.com)
Date: January 24, 2007 12:35PM

Check my old post here for the idea

[forum.wampserver.com]

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)

Options: ReplyQuote
Re: how to set password for MySQL
Posted by: liddlem (---.sa.bigpond.net.au)
Date: January 25, 2007 11:48PM

Hi yfastud
I followed your instructions, but now I get a MySql erro as follows.

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

I have un-installed and re-installed WAMP 4 time now to TRY correct the problem

Any ideas please

Options: ReplyQuote
Re: how to set password for MySQL
Posted by: Bao (---.ss.uci.edu)
Date: January 26, 2007 02:20AM

Thanks for all your help, I was able to get everything set up. Here's what I did:

I did the password instructions for both the MySQL option and phpMyAdmin options instead of just one, and it worked for me. Open the MySQL console, it will prompt you for a password, you can just press enter and then it should ask you to set one. After you set it,
you can create your own database and users with specific privileges to them. To create a database, type:

CREATE DATABASE <database name here>


Now change the current database to the mysql database. The mysql database comes with the mysql installation and stores all of the user and access info. create a specific user and a password for that user, to access this database. type the following commands:

use mysql

Type:

GRANT SELECT, INSERT, UPDATE, DELETE ON <database name here>.* TO <user name here>@localhost IDENTIFIED BY '<password here>'

thanks again everyone for all your help

Options: ReplyQuote
Re: how to set password for MySQL
Posted by: yfastud (---.cable.mindspring.com)
Date: January 26, 2007 05:21AM

In my post, I've already said you must set it up in 2 places

For first place, you can either use mysql console or phpmyadmin, and for second place is config.inc.php

Have fun

[www.jlbn.com] (testing web server)
[test.jlbn.com] (testing codes)
[forum.jlbn.com] (testing phpBB2)
[forums.jlbn.com] (testing phpBB3)
[mail.jlbn.com] (testing mailserver)
[ftp.jlbn.com] (testing ftp server)
[www.jlbn.com] (testing flashes)
[www.jlbn.com] (testing images)
[joomla.jlbn.com] (testing Joomla 1.0.10)
[fusion.jlbn.com] (testing phpFusion 6.01.6)
[nuke.jlbn.com] (testing phpNuke 7.9)
[nukep.jlbn.com] (testing phpNuke Platinum 7.6.b.4v2)
[pnuke.jlbn.com] (testing PostNuke 0.800-MS2)
[nukevo.jlbn.com] (testing phpNuke Evolution 2.0.1)

Options: ReplyQuote


Sorry, only registered users may post in this forum.