Menu
I've accidentally deleted my users table (removed all users) now whenever I try to access my database it says: "host localhost is not allowed to connect to this MYSQL Server". I've tried connecting directly, same error. I'm using apache xampp for this.
528
A quick solution is to create a new user with admin access: CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *. * TO 'username'@'localhost' WITH GRANT OPTION; CREATE USER 'username'@'%' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.
Enter 127.0. 0.1 for the host. The default username for a new MySQL installation is root, with a blank password. You can leave the port field blank unless your server uses a different port than 3306.
A very commonly asked question, try doing this (and it worked for me),
goto your mysql folder and there will be a file called my.ini. Simply add skip-grant-tables (without an argument) in the [mysqld] section as below:
[mysqld]
port=3306
skip-grant-tables
Save the file, restart your server. If the problem still exists, refer to this link.
124
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
