View Full Version : What is my MySQL username and password?
Chatmaster
05-12-2007, 10:10 PM
For the first time in my life I have to work with PHP and MySQL. I have installed WAMP5 on my Windows PC and started working on my new quest... Trying to get PHPBB working on my home PC so I can modify my new site I am setting up. It turned out to be a major time waster. Nowhere on the web could I find a simple explanation on how MySQL creates a user a password when you create a database. All the experts are so good in it they never realised that a dummy like me would need to know something like that, they simply mention CONTINUESLY add your username and password (Which I have no clue what it is). The result is that I have a database, but no clue as to what the Username and password is for it, lol.
Can any of the PHP/MySQL gurus here give me some help. I clearly need it!
Blazingpie
05-14-2007, 06:03 AM
Ok, I've never heard of WAMP5, as I normally setup the WAMP components seperately, in that order - Windows, Apache, MySQL, PHP. During the MySQL installation you get the option to install a password.
Surely there should of been a stage during installation where they asked you for a password? Have you tried 'root' as a username and a blank as a password?
Chatmaster
05-14-2007, 06:07 AM
Yah, the password asked by MySQL when opening it, is not the problem. That I have. My problem seems to be creating a User perhaps. I am not sure as to how MySQL go about creating a user for a specific database. The thing is, I get to the point to create the database, but then when connecting to it in PHP I need the Username and Password, which confuses me as I can not recall MySQL asking me to do this at any time.
Blazingpie
05-14-2007, 06:14 AM
ok, try 'root' as a username :) or 'localhost', sometimes these packages default to that for some reason.
Chatmaster
05-14-2007, 12:11 PM
Thanks Blazinpie, actually would have worked, I only saw your post now and it is exactly what the username was. :)
Ok, Thanks to Daniel and Gareth the problem has been sorted. It was a simple privilages issue. All I had to do was go into the Alias directory for PHPmyadmin and edit the alias file.
Changed
Order Deny,Allow
Deny from all
Allow from 127.0.0.1
to
Order Allow,Deny
Allow from all
Allow from 127.0.0.1
Thanks Daniel!
vBulletin® v3.8.2, Copyright ©2000-2012, Jelsoft Enterprises Ltd.