php – mysqli_real_connect (): (HY000 / 1045): access for user & # 39; root & # 39; @ & # 39; localhost & # 39; denied (with password: YES)

First of all, I commented that another bug had previously been fixed (mysqli_real_connect (): (HY000 / 1698): access for user # root; # 39; localhost # denied) if root permissions @localhost and the plugin were updated from the & # 39; user & # 39; table.

This new error will now be displayed to me when I try to log in to phpMyAdmin. All configuration of mysql, apache and php is done through the command console. So I did not use an installer like XAMP or Bitnami.

I'm pretty new with everything PHP, MySQL and databases, so if you can recommend a guide that would take me a bit, that would be great.

Thank you

Does anyone know what I can do? The most likely thing is that I skipped some steps in configuring the MySql server, although it would seem strange to me because I used it for several months for database practices in the faculty.

mysql – ERROR 1794 (HY000): The slave is not configured or could not be properly initialized

This is my my.cnf file

[mysqld]

server_id = 1
log_bin = /var/log/mysql/mysql-bin.log
log_bin_index = /var/log/mysql/mysql-bin.log.index
relay_log = / var / log / mysql / mysql-relay-bin
relay_log_index = /var/log/mysql/mysql-relay-bin.index
expire_logs_days = 10
max_binlog_size = 100M
log_slave_updates = 1
Auto-increment increment = 2
Auto increment offset = 1
Binding address = 0.0.0.0

I clearly mentioned the server-d in my.cnf, but I get this error when I stop the slave.

Stop slave;
ERROR 1794 (HY000): Slave is not configured or could not be initialized properly. You must set at least –server-id to enable either a master or a slave. Additional error messages can be found in the MySQL error log.

Anyone can help me as soon as possible.

mysql – PHP – mysqli :: real_connect (): (HY000 / 2002): Invalid argument in the file

In one work project, I test a PHP service on MySQL 5.6 loaded on a robust Google Calculation Engine VM. After passing a certain number of requests per second in my load test, mysql seems to start cracking and gives me errors like:

mysqli :: real_connect (): (HY000 / 2002): Invalid argument in

I've confirmed that we'll pass the same arguments to mysqli real_connect before and after the alerts start failing.

The VM memory and CPU consumption is very low, we have no limits when writing iOPS (our load test is hard to write) and none of the charts in PMM reveal anything that goes wrong at this time.

Any ideas why this could happen?

ERROR 1130 (HY000) must not connect to this MariaDB server if there is a problem in granting the permission

I am trying to connect to Mariadb, who is running another container. The error is displayed
$ mysql -u root -h test-mysql -port 3306

ERROR 1130 (HY000): host # test_1_73f6dacd1d23.test_bluenet & # 39; may not connect to this MariaDB server

MariaDB server:
I tried the following
MariaDB [(none)]> SELECT host, user FROM mysql.user;

+ -------------- + ------ +
| Host | User |
+ -------------- + ------ +
| 00a7a6a8d0af | |
| 00a7a6a8d0af | Root |
| 127.0.0.1 | Root |
| :: 1 | Root |
| localhost | |
| localhost | Root |
+ -------------- + ------ +
6 rows in the set (0,001 sec.)

MariaDB [(none)]> ALL PRIVILEGES ON , Roots & # 39; @ & # 39; # 39% & ;;

ERROR 1133 (28000): A matching row can not be found in the user table