Questions tagged [mysql5]
134 questions
18
votes
3 answers
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 my remote server, and try connecting to its own mysqld using SSL (MySQL server is 5.5.25)..
mysql -u -p --ssl=1…
carpii
- 521
- 2
- 4
- 12
17
votes
3 answers
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 which should keep sync with the new Master server, to do so I have to point my DB domain name master-db.myawsserver.com…
Imad Touil
- 273
- 1
- 2
- 5
14
votes
8 answers
"Error 1067: The process terminated unexpectedly" when trying to install MySQL on Win7 x64
I've run into a brick wall trying to install MySQL v5.5 on my machine.
My PC is Windows 7 x64, Enterprise edition.
MySQL installs fine, but when I run the "MySQL Instance Configuration Wizard", it pauses forever on the step "Start Service" (I can…
Contango
- 1,130
- 5
- 15
- 31
11
votes
3 answers
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" at a root unix prompt and it asks for no password and still allows me root access. I am not understanding why "mysql…
djangofan
- 4,172
- 10
- 45
- 59
9
votes
8 answers
MySQL: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
All of a sudden my local MySQL 5.5 server stopped running on my Windows XP SP3.
I also have WAMP Apache and WAMP MySQL installed, but WAMP MySQL is not running. Error log shows:
Can't start server: Bind on TCP/IP port: No such file or directory
Do…
Steve
- 415
- 2
- 6
- 18
8
votes
4 answers
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. Now the DB server is getting hammered, hard, to the tune of about 300mb/min in binary logging for the replicate. As you could…
blacktip
- 301
- 1
- 2
- 5
6
votes
3 answers
mysql error 1062 'duplicate entry' when restoring backup
Sorry, I seen similar threads but I still couldn't find it addressing my issue plus, I needed some more info on this.
Requirement: To create an exact replica 'db4' of an existing DB 'db3'.
Procedure followed:
mysqldump -uuser -ppass db3 > db3.sql…
user492160
- 139
- 1
- 3
- 11
6
votes
2 answers
Insert one data to MySQL table without login
MySQL details:
MySQL username: root
MySQL password: z
To run MySQL query without login, the command is:
mysql -u root -pz -e "mysql-query-here"
So, if I want to create database with name db1, it will become:
mysql -u root -pz -e "CREATE DATABASE…
Roberto Apasajja
- 77
- 1
- 1
- 4
6
votes
2 answers
Caching db results - need a nudge on how to start
I have a project coming up where one of the requirements will be to cache what's essentially read-only data in order to lessen the strain on the db. I'm just a bit confused on how caching works with a db.
How does caching work? I've seen something…
Major Productions
- 175
- 6
- 17
4
votes
2 answers
Error 2013: Lost connection to MySQL server during query when executing CHECK TABLE FOR UPGRADE
I just upgraded Ubuntu from 11.10 to 12.04. My rails app now returns the (passenger) error "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) (Mysql2::Error)". I get a similar error when I try to access mysql at…
Dean Richardson
- 91
- 1
- 1
- 4
4
votes
4 answers
MySQL : Separate Log File for Each Database
I have a server with multiple databases on it. Its actually an instance on AmazonRDS so I do not have access to the my.cnf file. What I am trying to do is a create a log for each database separately that records the queries that were previously ran…
Devin Dixon
- 161
- 1
- 5
4
votes
1 answer
Is it safe to modify innodb_data_file_path value for mysql 5?
I recently experienced data corruption after changing the value of this parameter in my.cnf from :
innodb_data_file_path = ibdata1:10M:autoextend:max:128M
to :
innodb_data_file_path = ibdata1:10M:autoextend:max:256M
I am not completely sure this…
drcelus
- 1,233
- 4
- 14
- 27
4
votes
2 answers
MySQL 5.5.16 allows anonymous connections
Apparently, I can connect to MySQL (at least from my localhost) without having to provide any username or password. I can even put anything as username, as long as the password is empty. I have access to the information_schema and test databases. I…
f.ardelian
- 147
- 1
- 7
4
votes
2 answers
Are Master-Master database collisions a problem even with auto increment?
I've done quite a lot of reading into this and I'm still I'm not sure where I stand.
Am I going to get database collisions (and then corruption) with two Masters both receiving writes ?
Now that MySQL (I'm using 5.1 on Debian and Ubuntu) has…
Jonathan Ross
- 2,173
- 11
- 14
3
votes
3 answers
mysql best practices with replication of the mysql db (grants storage)
is there a best practice to ensure that privileges do not get replicated to mysql slave servers? the problem is, there a maintenance users in the mysql table that have different passwords on each box. things like startup/shutdown scripts use these…
imaginative
- 1,941
- 9
- 32
- 48