Welcome to WebmasterWorld Guest from 3.214.184.124

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

mySQL PHP and Apache

Yes, again..sorry but...

     
9:01 pm on Apr 20, 2004 (gmt 0)

New User

10+ Year Member

joined:Mar 12, 2004
posts:18
votes: 0


Hello!
Apologies in advance as I know this has been dealt with before, but previous answers don't seem to be working. If I try to access my 'http://localhost/phpmyadmin/index.php' file WITH a password it won't play - but if I leave the password blank it lets me in?
It gives me a warning in big red letters telling me.. 'Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.'

I have entered the password in every config file everywhere I can think of, but obviously to no avail. I've been on this for 2 days and am going to cry soon!

Any ideas? Please?
Jim

9:15 pm on Apr 20, 2004 (gmt 0)

Administrator

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 24, 2001
posts:15756
votes: 0


it sounds like you need to update the root password in MySQL itself. The initial root password upon install is blank and must be changed post installation.

5.5.2 Securing the Initial MySQL Accounts [dev.mysql.com]

9:28 pm on Apr 20, 2004 (gmt 0)

New User

10+ Year Member

joined:Mar 12, 2004
posts:18
votes: 0


thanks Jatar - I'm trying that now, but if I try to connect to the mysql server from the command line to change tthe password, it won't let me connect:

c:\mysql\bin\mysql test

Also - I can't remember how you get to

shell>

sorry to be so dense.

cheers
Jim

11:08 pm on Apr 20, 2004 (gmt 0)

New User

10+ Year Member

joined:Jan 14, 2004
posts:7
votes: 0


you have to update your permissions for the mysql database
11:48 pm on Apr 20, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 13, 2003
posts:775
votes: 0


On the first phpmyadmin screen you'll see a 'permissions' link. Click on that and then either delete the users or change passwords. Once you've done that then phpmyadmin won't work anymore and you'll have to open the config.inc.php file and change the user and password variables.

If you are using this locally for development I wouldn't worry changing the permissions. On the production server it will be critical.

6:18 pm on Apr 21, 2004 (gmt 0)

New User

10+ Year Member

joined:Mar 12, 2004
posts:18
votes: 0


Thanks people - I got it going in the end...more by luck than judgement!

My next problem is how to upload it to a server....where does the mysql part go?

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members