![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql cluster
code_tailor
这个作者很懒,什么都没留下…
展开
-
How to Run MySQL as a Normal User
User On Windows, you can run the server as a Windows service using a normal user account. On Linux, for installations performed using a MySQL repository or RPM packages, the MySQL server mysqld should be started by the local mysql operating system user. St转载 2021-03-25 15:20:21 · 90 阅读 · 0 评论 -
mysql check variables
mysqld --verbose --help原创 2021-03-25 14:06:36 · 105 阅读 · 0 评论 -
sudo su doesn‘t change users for mysql
19 su invokes the other user’s login shell as given in /etc/passwd. In your case that’s /bin/false so you don’t get any interactive shell. Use sudo -u test /bin/bash or sudo -u test /usr/bin/mysql or something like that instead.转载 2021-03-25 11:12:08 · 62 阅读 · 0 评论 -
ERROR 1449 (HY000): The user specified as a definer (‘mysql.infoschema‘@‘localhost‘) does not exist
2 After lots of attempt,the solution is delete user mysql.infoschema first and then do vamshi’s steps: Create user: mysql> CREATE USER ‘mysql.infoschema’@‘localhost’ IDENTIFIED BY ‘password’; Query OK, 0 rows affected (0.00 sec) Grant permissions: mysql转载 2021-03-25 10:08:28 · 343 阅读 · 0 评论 -
mysqld_multi: How to run multiple instances of MySQL
The need to have multiple instances of MySQL (the well-known mysqld process) running in the same server concurrently in a transparent way, instead of having them executed in separate containers/virtual machines, is not very common. Yet from time to time th转载 2021-03-25 08:11:21 · 183 阅读 · 0 评论 -
HOW TO FIND MYSQL BINARY LOGS, ERROR LOGS, TEMPORARY FILES?
Have you ever spent a lot of time trying to locate where MySQL keeps some file? Here is a quick way to find all this information in one place. The obvious way is through examining database options in my.cnf or looking at the output of SHOW GLOBAL VARIABLES原创 2021-03-18 22:32:11 · 74 阅读 · 0 评论