Import MySQL data failed with error 1839
If you run a SHOW MASTER STATUS\G you’ll see something like this: mysql> show master status\G *************************** 1. row *************************** File: mysql-bin.000299 Position: … Read more
mysql5
Can expire_logs_days be less than 1 day in MySQL?
So… yesterday I received an “after the fact email” about a campaign that has started for one of the services that I run. … Read more
MySQL: Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist [closed]
Closed. This question is off-topic. It is not currently accepting answers. Questions on Server Fault must be about managing information technology systems in … Read more
After setting root password why does MYSQL still allow me to login without a password?
After setting root password why does MYSQL still allow me to login without a password from the command line? I can type “mysql” … Read more
“Error 1067: The process terminated unexpectedly” when trying to install MySQL on Win7 x64 [closed]
Closed. This question is off-topic. It is not currently accepting answers. Questions on Server Fault must be about managing information technology systems in … Read more
Can’t find the private IP address for my Amazon-RDS instance
I moved my Master/slave database architecture to Amazon RDS and everything works fine. But I have a slave out of the RDS service … Read more
Cant connect to mysql using self signed SSL certificate
After creating a self-signed SSL certificate, I have configured my remote MySQL server to use them (and SSL is enabled) I ssh into … Read more
Are table names in MySQL case sensitive?
Are table names in MySQL case sensitive? On my Windows development machine the code I have is able to query my tables which … Read more
How can I get a list of user accounts using the command line in MySQL?
I’m using the MySQL command-line utility and can navigate through a database. Now I need to see a list of user accounts. How … Read more
