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…
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
1
2 3
8 9