invalid settings. mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server
I was getting the following error while accessing http://localhost/phpmyadmin on xampp server
MySQL said: Documentation Cannot connect: invalid settings. mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server Connection for controluser as defined in your configuration failed. mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server 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.
so I added 'skip-grant-tables' in my.ini and I can access now. However While installing the Magento2 in the xampp server, I am receiving the following error :
Database user does not have enough privileges. Please make sure SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, TRIGGER privileges are granted to database 'magento2'.
Will I not be able to install Magento unless 'skip-grant=tables' is removed? But after doing so I am not able to even access phpmyadmin. What is supposed to be done to solve the issue?
PS: I had installed WInNMP but after I realized this problem I uninstalled it but it didnt seem to solve the issue
It seems there was a problem in the user table of the MySQL
Repaired it and then created the root user again which previously seems to have got deleted and I also removed the 'skip-grant-tables' from my.ini from Xampp control panel's configuration. Stopped and started the Xampp and Mysql server from the Xampp control Panel
- phpMyAdmin configuration on Zend server community edition
- Why would Mysql return "error Column cannot be null"?
- How to repair corrupted table 'global_priv' in localhost xampp
- How to add auto-increment to column in mysql database using phpmyadmin?
- How to import Excel file into mysql database using phpmyadmin
- PhpMyAdmin Import Error-MySQL server has gone away/Unrecognized Keyword
- How to export all the databases with phpmyadmin
- I tried to open my Laravel application which was developed 2yrs ago and when I register a user I see the following error
- How to Increase Import Size Limit in phpMyAdmin
- Why my tables' names are converted into lowercase in phpmyadmin?
- Import some database entries through PHPMyAdmin with overwrite
- PhpMyAdmin install errors
- Nginx 403 Forbidden for location and localhost
- How do I change the phpmyadmin port?
- phpmyadmin export selected data from SQL to excel
- Enum value is not set, BUT is not null
- There is mismatch between HTTPS indicated on the server and client
- PhpMyAdmin is showing some Warnings
- Update hierarchical columns with primary key value when they are null
- Php tried to connect the mysql server. and server reject the connection connection for user control as defined has failed
- Error loading MySQLdb Module 'Did you install mysqlclient or MySQL-python?'
- invalid settings. mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server
- Script timeout passed, if you want to finish import, please resubmit the same file and import will resume
- phpMyAdmin: secret passphrase?
- How To Use IF Statement and Local Variables In Stored Procedures
- SQL: Set default value to NULL for all columns without default value
- Storing emojis in MySql database. Showing ??? in phpmyadmin
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- #1030 - Got error 176 "Read page with wrong checksum" from storage engine Aria
- MySQL database shows in phpMyAdmin but not the command line client