I was able to install XAMPP to my PC successfully and have been
using it. 2 questions:
How do i change the default username(root) and password to
something else.And how do I access the MySql prompt to practice SQL
commands.
How do i change the default username(root) and password to
something else
And how do I access the MySql prompt to practice SQL
commands.
The MySQL Command Line Client you can found in the directory "\xampp\mysql\bin".
Please I wonder, why they do not show?
Wiedmann wrote:The user you are using for the connection does not have enough privileges to see more.
define("DB_SERVER", "localhost");
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
Error
MySQL said:
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 109 guests