How do i change the default username(root) and password to
And how do I access the MySql prompt to practice SQL
The MySQL Command Line Client you can found in the directory "\xampp\mysql\bin".
Wiedmann wrote:The user you are using for the connection does not have enough privileges to see more.
define("DB_USER", "root"); //change when live
define("DB_PASS", ""); // change when live
I am > cmd > cd\xampp\mysql\bin and I run command line > mysql
show databases; = Only 2
does not root , no password on localhost have FULL access?
Welcome to phpMyAdmin
Cannot connect: invalid settings.
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.
Users browsing this forum: No registered users and 59 guests