linux Archives - Magenaut

I look at the documentation and don’t see any practical implementation case in the examples. Does anybody know how to ensure that incoming requests to my database server are processed via Intel NVMe SPDK? Answers: Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve … Read more

Creating and using an SQL variable after some set text

November 27, 2022 by Magenaut

I’m needing to set some text into a field within a row, and use a SQL variable as part of that text. I’m then using this sql statement in a bash script.

error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock

November 24, 2022 by Magenaut

My problem started off with me not being able to log in as root any more on my mysql install. I was attempting to run mysql without passwords turned on… but whenever I ran the command

How do I find the MySQL my.cnf location

November 24, 2022 by Magenaut

Is there a MySQL command to locate the my.cnf configuration file, similar to how PHP’s phpinfo() locates its php.ini?

MySQL – ERROR 1045 – Access denied

November 24, 2022 by Magenaut

In some way I have managed to get this error when I try to access into MySQL via the command line:

Can’t connect to MySQL server error 111

November 24, 2022 by Magenaut

I installed mysql server on linux box IP = 192.168.1.100 but when i try to connect to this IP it alway error(111). but use localhost and 127.0.0.1 is OK. [email protected]# ifconfig | grep “inet addr” inet addr:127.0.0.1 Mask:255.0.0.0 inet addr:192.168.1.100 Bcast:192.168.1.255 Mask:255.255.255.0 [email protected]# mysql -ubeer -pbeer -h192.168.1.100 ERROR 2003 (HY000): Can’t connect to MySQL server … Read more