349 reputation
416
bio website dotancohen.com
location
age 37
visits member for 3 years, 3 months
seen Nov 8 at 11:05

Nov
24
awarded  Popular Question
Sep
12
awarded  Popular Question
Sep
11
accepted ON DUPLICATE KEY UPDATE faster than UPDATE
Aug
24
accepted Set MySQL option to restore MySQL server after deleting ibdata1
Aug
24
comment Set MySQL option to restore MySQL server after deleting ibdata1
Thank you. I've bitten the bullet and installed an older version of the OS (Ubuntu 12.04). Thank you, I have learned much from this post.
Aug
18
comment Cannot configure nor start MySQL
Yes, of course! Only the grep process itself shows up.
Aug
18
comment Cannot configure nor start MySQL
Thanks. In fact, mysqld_safe dies right away: 40818 16:52:52 mysqld_safe Logging to '/var/lib/mysql/bruno.err'. , 140818 16:52:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql , 140818 16:52:54 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended.
Aug
18
comment Cannot configure nor start MySQL
Thank you. I completely removed any trace of 5.6, rm'ed both /var/lib/mysql and /var/log/mysql. The mysql_install_db command failed because resolveip was not found. I then installed mysql-server-5.5 (which apparently is not installed along with mysql-server-core-5.5) to get resolveip. During the install of mysql-server-5.5 I got the Unable to set password for the MySQL "root" user error again, back to square one!
Aug
18
comment Cannot configure nor start MySQL
Actually, I would prefer 5.6 and I don't use eclipse.
Aug
18
comment Cannot configure nor start MySQL
Thank you, if I cannot get through this then I'll try the instructions that you link to.
Aug
18
comment Cannot configure nor start MySQL
@Vérace: No, there is neither my.cnf nor .my.cnf in /home/dotancohen.
Aug
18
revised Cannot configure nor start MySQL
added 4570 characters in body
Aug
18
comment Cannot configure nor start MySQL
Thank you Craig. I was able to reinstall mysql-server-core-5.5 but that did not resolve the issue. I'll add that to the question.
Aug
18
comment Cannot configure nor start MySQL
Thank you. You are right, I had that line as well though I missed it. Now, mysql won't start but nothing is written to the logs. I'll update the question.
Aug
18
comment Cannot configure nor start MySQL
Thank you. The string timestamp was found only in etc/mysql/my.cnf and I've comented it out. Yet, I still get the same mention of it in the log.
Aug
18
comment Cannot configure nor start MySQL
@CraigEfrein: No, port 3306 is not being listened to. I even restart the system to see if MySQL would start on boot, but it didn't.
Aug
18
asked Cannot configure nor start MySQL
Aug
13
comment ON DUPLICATE KEY UPDATE faster than UPDATE
@Ohadi: That does not seem to be the case considering that this is a DML query. Additionally, the first UPDATE query never finishes.
Aug
11
comment Set MySQL option to restore MySQL server after deleting ibdata1
As mentioned in the OP, I cannot reinstall MySQL because the OS is no longer supported. I tried that! I also mention why upgrading or downgrading the OS version is not feasible.
Aug
11
asked Set MySQL option to restore MySQL server after deleting ibdata1