0

I installed Xampp and have the apache, FTP and MySql server running.

Initially i was getting an error:-

error :-

MySQL said: Documentation
1045 - Access denied for user 'root'@'localhost' (using password: NO).

Connection for controluser as defined in your configuration failed.

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

But then I went to the PhpMyAdmin folder under Xamp and made changes to the config.inc.php file to include my password in the $cfg['Servers'][$i]['password'] ='' section.

Now I am able to login to Mysql.

**

But the main problem is:-

**
I have a few schemas and tables already in the database, but when i log in to the database using the PhpMyAdmin I am unable to view those schemas and tables. Please could you help out, as those schemas are the ones that I need to incorporate in my webpage.

Edited by debal: specify

4
Contributors
11
Replies
17
Views
4 Years
Discussion Span
Last Post by debal
0

I use Toad for mysql to insert and remove data from the database, and when i login through toad i use "root" as username and "1234" as password.

But when i closely looked into the config file i saw a part where they had login without password="true" i changed that to "false" and now when i try to login using "root" and "1234" i get the error message cannot connect to mysql. The mysql service is running in the xampp control pannel.

Edited by debal: mistake

0

i changed that to "false" and now when i try to login using "root" and "1234" i get the error

Change it back

0

Change it back

i changed it back to true, now i can login with only root as the username and no password, but cannot login with "root" and "1234", and the schema are still not visible...

0

@debal

In the future try to open one thread and close the other! You'll making Squidge going back and forward with 2 threads. That's not nice if someone is helping you and mention things already on the other thread.

0

Ah it works now.. I uninstalled the previous installation of Mysql and then installed Xampp, and everything works fine.. Thanks a lot guys. :)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.