Creating a New Database in MySQL localhost

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Creating a New Database in MySQL localhost

Postby SorenCreative » 02. January 2011 17:00

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. :?:
SorenCreative
 
Posts: 4
Joined: 02. January 2011 16:36

Re: Creating a New Database in MySQL localhost

Postby Altrea » 02. January 2011 17:49

Hi SorenCreative,

SorenCreative wrote: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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6536
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64

Re: Creating a New Database in MySQL localhost

Postby SorenCreative » 03. January 2011 06:29

Altrea wrote:Hi SorenCreative,

SorenCreative wrote: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. :?:
SorenCreative
 
Posts: 4
Joined: 02. January 2011 16:36

Re: Creating a New Database in MySQL localhost

Postby Altrea » 03. January 2011 09:19

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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6536
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64

Re: Creating a New Database in MySQL localhost

Postby SorenCreative » 03. January 2011 09:52

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)
Image

Thanks for your patience.
Soren
SorenCreative
 
Posts: 4
Joined: 02. January 2011 16:36

Re: Creating a New Database in MySQL localhost

Postby SorenCreative » 03. January 2011 09:54

SorenCreative
 
Posts: 4
Joined: 02. January 2011 16:36

Re: Creating a New Database in MySQL localhost

Postby Altrea » 03. January 2011 09:58

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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6536
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 45 guests