设置无效。mysqli_real_connect()：(HY000/1130)：不允许主机'localhost‘连接到此MariaDB服务器

Question

访问xampp服务器上的http://localhost/phpmyadmin时出现以下错误

​

​

  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.

所以我在my.ini中添加了“跳过授权表”，现在就可以访问了。但是，在xampp服务器中安装Magento2时，我收到以下错误：

    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'.

我是否无法安装Magento，除非'skip-grant=tables‘被移除？但这样做之后，我甚至无法访问phpmyadmin。应该做些什么来解决这个问题？

PS:我已经安装了WInNMP，但当我意识到这个问题后，我卸载了它，但它似乎没有解决这个问题

Answer 1

MySQL的user表似乎有问题

修复了它，然后再次创建了根用户，之前似乎已经被删除了，我还从Xampp控制面板的配置中删除了my.ini中的“跳过授权表”。从Xampp控制面板停止和启动Xampp和Mysql服务器