New answers tagged

0

First issue: I had a typo in my sender-login-maps.cf file. Was saying 'ser' rather than 'user' when specifying the dbuser. Second issue: After I was able to send mail, I then started the firewall however stopped receiving mail. This was due to incoming connections to tcp 25 being blocked. I didn't allow this as I thought if I've configured smtpd to use 587 ...


0

I had a similar issue. It had happened when I have created a clone from the running Amazon MySql RDS Slave. The problem was resolved by creating a snapshot and restoring as a new instance.


2

I installed Notepad++ and opened both the modified file and the original, and they indeed have different encodings. The original was UTF-8, and the modified file is UTF-8-BOM. I changed the encoding back to UTF-8 on the modified file, and it solved the issue. So, apparently, the problem is that MS Notepad changes the encoding to UTF-8-BOM, and that causes ...


2

http://mysql.rjweb.org/doc.php/mysql_analysis That has two parts -- one is a deeper dive into the settings on your machine. The other is capturing the slowlog. High CPU almost always means poor indexing and/or poor formulation of queries. The slowlog is a very efficient way to find the "worst" queries. Then we can discuss how to improve them. ...


0

It looks like I probably found an answer. This is because if you specify "-h localhost" - it will connect you to MySQL socket, and --port will be ignored (no TCP/IP will be used, and hence the --port option has no meaning). To connect to a different port, simply use an address which is not "localhost", but 127.0.0.1: Credits to: https://...


0

You may want to reconsider this situation reported in your error log - Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195596] Free swap = 0kB Jul 20 10:40:55 ITMI-PHSE-MYSQL kernel: [597449.195597] Total swap = 0kB I would recommend 6 GB minimum swap for your OS to avoid OOM. Better to be slow for some milliseconds or seconds than OOM stopped.


0

So basically by default Mysql now (on most distributions like Ubuntu/Debian) is using "caching_sha2_password" plugin for user authentication and "auth_socket" plugin for 'root' user. Previously it used to use "mysql_native_password". "auth_socket" plugin does not require to set any password instead it uses the ...


0

@Venkateswara Rao and @Martin Roy 's answer work great if you don't care if changes to dockerized DB are still put in a Volume. In my case, I wanted a Docker Image prepopulated with data, but in a project where we have frequent Database Migrations. Thus, i wanted to occasionally make a DB Container, run migrations, then somehow push those changes back up ...


0

be sure you are running mysql_secure_installation as sudo if you dont have system root access or system root is disabled. I ran in this same problem before where I disabled root login systemwide and tried running mysql_secure_installation without sudo.


0

For me, I ran some cache clearing operations to free up space using tools like Stacer, and then MySQL started showing problems. Use this to get some clues first grep mysql /var/log/syslog | grep ERROR If the error says, Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory then clearly, the log files were cleaned up. ...


0

You can bypass the ProxySQL cache. Please try following: SELECT /*!40001 SQL_NO_CACHE */ * FROM sbtest1 ORDER BY id DESC LIMIT 3 ;


-2

I could solve this issue using the answers from here and here.


0

If you are using Amazon RDS or Aurora, remember to reboot the writer instance after applying bin_log in cluster parameter. This needs to be done manually. Rebooting writer instance will also cause read replicas to reboot. Before rebooting you will get Empty set.


0

Why would CHAR_LENGTH not return 0 for a NULL value? Because any function (except the likes of NVL(), obviously) will return NULL if passed a NULL argument. Formally: f(NULL) == NULL More importantly: NULL != '' An empty string is .. well .. an empty string. A NULL marks the absence of data. Not the same thing. (Unless, of course, you're trying to use ...


0

I would suggest that you initially duplicate your existing on-prem, MySql configuration onto your Azure VM. All the same settings. That way, you're comparing like with like. Right now, you have too many changes happening at the same time and you can't see which one(s) are causing the problem. ... we notice is that although some of the queries take 30+ ...


1

Surround each with COALESCE(..., 0). mysql> SELECT CHAR_LENGTH(null), CHAR_LENGTH(''), CHAR_LENGTH('abc'); +-------------------+-----------------+--------------------+ | CHAR_LENGTH(null) | CHAR_LENGTH('') | CHAR_LENGTH('abc') | +-------------------+-----------------+--------------------+ | NULL | 0 | 3 | +------...


2

Pavel Bernshtam suggested a perfect solution openssl rsa -in client-key.pem -out client-key.pem openssl rsa -in server-key.pem -out server-key.pem but I needed also to assign the owner to the certs folder, otherwise mysql can't read the key file chown -R mysql:mysql /path/to/certs


0

I think LVM needs to be established while the disk is idle -- it involves carving out part of the device. LVM handles the entire disk partition, not just a directory tree. Between creating the snapshot and using it on another server, you must copy it to the other server. I prefer to stop mysqld while doing the snapshot, but theoretically that is not ...


0

SHOW PROCESSLIST only shows connections for the user running that command. Be sure to connect as root to get the complete list. "root" is actually more powerful than you need; there may be some other user ("admin"?) that is powerful enough. In terms of GRANT, all the 'user' needs is PROCESS. Once you get the processlist, Time will ...


2

The reason is that MySQL uses socket authentication option by default for the root user. If you want to disable it, you need to change Authentication plugin for the root account from "Socket authentication" to "Native MySQL authentication".


3

Probably socket authentication where MySQL basically authenticates you if the username calling the mysql binary matches a known username to MySQL. The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket file. The plugin uses the SO_PEERCRED socket option to obtain information about the ...


0

You should check in /var/log/mysql, as some package maintainers set the application so it logs there the initial password. You should use that password, or stop the service, and start it passwordless by launching "mysqld_safe --skip-grant-tables" and then change root password with


0

The mysql-server package comes pre configured with a utility called mysql_secure_installation that is used to set up a secure starting point for MySQL server, by deleting anonymous users and allowing you to specify the desired password strength policy. mysql_secure_installation is a shell script available on Unix systems, and enables you to secure the MySQL ...


0

You most likely saved your credentials in the .my.cnf file.


Top 50 recent answers are included