Creating a New Database in MySQL localhost

[SorenCreative]

Hello Everyone,

I am very new to XAMPP and any valuable help from the pros and veterans will be highly appreciated.

I followed the Read Me guide and successfully installed the XAMPP in my pc (Vista).
I also successfully changed the Password for MySQL and XAMPP Directory. The note says that for my New MySQL Password to take effect I should log-in
to MySQL Admin. When I click it, I was directed to phpMyAdmin where I am asked for a Username and a Password. I was confused on what to input (whether the MySQL or the XAMPP account). But I was able to log-in using the info on the folder (xampp/security/txtfile).

The problem is I cannot create a database. The following error message appears:

#1044 - Access denied for user 'pma'@'localhost' to database 'my database name'

Could anyone help me do this successfully? Thank you so much in advance.

[Altrea]

Hi SorenCreative,

I also successfully changed the Password for MySQL and XAMPP Directory

So you have used the xamppsecurity script? This script changes your root and pma User Password for MySQL.
Please take again a look in your xampp/security/txtfile. Is there a password for your pma User?

If so, please open the file c:\xampp\phpMyAdmin\config.inc.php in your script or plaintext editor.
Search for the line with the beginning $cfg['Servers'][$i]['controlpass']
Write your pma password into the single quotes and save the file.

After that try again to log in to phpmyadmin if the message is gone.

[SorenCreative]

Hi SorenCreative,

If so, please open the file c:\xampp\phpMyAdmin\config.inc.php in your script or plaintext editor.
Search for the line with the beginning $cfg['Servers'][$i]['controlpass']
Write your pma password into the single quotes and save the file.

Hi Altrea,

Thanks for your help.
I opened config.inc and notice that my pma password was already written there.
Now, I am trying to access phpMyAdmin to try to create database but can't seem to gain access.

As I review the Read Me guide, i came across with this ff information:

"After changing the password you'll have to reconfigure phpMyAdmin to use the new password, otherwise it won't be able to access the databases.
To do that, open the file config.inc.php in \xampp\phpmyadmin\ and edit the following lines:

$cfg['Servers'][$i]['user'] = 'root'; // MySQL User
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // HTTP authentification

So first the 'root' password is queried by the MySQL server, before you can access phpMyAdmin."

In the config.inc.php I noticed that the script looks like this: (I Copied and Pasted the ff)

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'cookie'; /* Authentication method (config, http or cookie based) */
$cfg['Servers'][$i]['user'] = 'root';

What am I going to do now? can't seem to figure out. Thanks again.

[Altrea]

First you should log out of phpmyadmin if you are logged in any more.
After that clean your Browser cache and close all Browser windows to end up all open sessions.

Be sure that Apache and MySQL are running and then open your Browser with the url of phpmyadmin ( http://localhost/phpmyadmin ) again. You should see a login-screen (thats what the changes in the phpmyadmin config effects).
In this login screen type in the user root and the password you have choosen for this user.

[SorenCreative]

Thanks again Altrea. You been very helpful.

I clear the browsers cache already; XAMPP CP MySQL is running; Apache cannot start; And when click MySQL Admin or type http://localhost/phpmyadmin/ the result is always like this: (I capture a screenshot for you to see)


Thanks for your patience.
Soren

[SorenCreative]

Image URL is not working properly, here's the link instead.

http://www.facebook.com/photo.php?fbid=186412881384182&set=a.101179079907563.2913.100000464139878

[Altrea]

I haven't got a facebook account, so i can't see images there.

Okay, your Apache don't starts. Thats the first problem that should be solved. Without Apache no Websites.
So please try to start Apache in the control Panel. If that don't works take a look into your \xampp\apache\logs\error.log file.

Most commonly Port 80 or Port 443 is already taken. So be sure you haven't started Skype, Teamviewer or other Programs which are well known to take these Ports.