Results for “MySQL”

A MySQL instance on Alibaba Cloud experienced website anomalies. The MySQL error log showed the following error: Sort aborted: Error writing file '/home/mysql/log/tmp/MYFo1tXI' (Errcode: 28 – No space left on device …

Whether for CPU backups or daily export operations, you need to export tables as SQL files …

MariaDB is a great open-source MySQL fork alternative (alongside others like Percona MySQL), but before switching from MySQL to MariaDB, you really need to understand the basic version correspondence between them. Otherwise, you’re likely to run into many …

yum -y install sysbench

echo "* hard nofile 65535
* soft nofile 65535
">>/etc/security/limits.conf

ulimit -a

core file size (blocks, -c) 0
data seg size (kbytes, -d) unlim …

Create user fs_cloud with password TMW7YxxjnaPc6kxX:
CREATE USER 'fs_cloud'@'%' IDENTIFIED BY 'TMW7YxxjnaPc6kxX';

Create database fs_cloud:
create database fs_cloud default charset utf8 c …

Modify the configuration file and add skip_grant_tables. Edit the configuration file:
vi /etc/my.cnf
Add the following under the [mysqld] section of the configuration file:
skip_grant_tables

Restart MySQL:
service mysqld restart
Access the database without a password and set a new one. Enter without a password:
mysql …

Error message as follows:
Error when connecting to server: Your password has expired. To log in you must change it using a client that supports expired passwords.

Log into mysql, set a new password, and set it to never expire:
my …

mysqlslap connection test error as follows:
mysqlslap: Cannot run query INSERT INTO t1 VALUES (73673339,'BN3152Gza4GW7atxJKACYwJqDbFynLxqc0kh30YTwgz3FktQ43XTrqJ4PQ25frn7kXhfXD8RuzN1j8Rf3y8ugKy6es3IbqPJM6y …