mysql-5 : Version of MySQL Starting with MySQL 5.0

learn more… | top users | synonyms

1
vote
0answers
37 views

After logging into MySQL 5.6 successfully as root, it says access denied for root, ERROR 1045 (28000)

I recently used MacPorts to upgrade from MySQL 5.5 to 5.6. I can use my database fine on my laptop. I tried to enable remote access to the database so I could edit the database using DB clients on ...
0
votes
1answer
25 views

How to backup MySQL databases when the MySQL server is off?

My MySQL server does not start, as according to the guides I found over the internet, the best solution is to re-install MySQL server (with apt-get purge). However, this process will delete my ...
0
votes
1answer
23 views

How to remove few tables from a large SQL file?

I have a SQL file with size around 3 GB. So this takes some long time to restore every time when i took recent dump from production. In this one table 'access_log' itself took 2.2 GB which is just a ...
-1
votes
1answer
34 views

Mysql window closing immediately after clicking on it [on hold]

I have done mysql installation like ten times now every time the installation is success but while trying to open it the window closes immediatelty. I have read the various post about starting the ...
0
votes
0answers
47 views

Access MySQL running on VirtualBox Win7 guest from a VirtualBox XP guest

I have a Windows 7 host, and 2 VirtualBox guest machines running on it. One has Windows7 as well and running a MySQL 5.6 server. The other guest has Windows XP. I want to run a software (for testing ...
0
votes
1answer
3k views

Cannot connect to mysql server using IP Address

I am trying to connect to mysql using an ip, but I am getting this error: ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (111) I can connect using localhost instead of an ...
0
votes
0answers
516 views

Raspberry Pi: mvoe home & var folders to USB HDD?

I have a Raspberry Pi running raspian. I've installed Apache2, PHP & MySQL. Apache & MySQL are both configured to use sub-directories of /var. I'd like to use a directory on my USB HDD ...
0
votes
1answer
204 views

Ubuntu 10.04 to 12.04, mysql5 causes upgrade hang

I'm doing a release update from 10.04 to 12.04. The upgrade process walked me through all the conflicting .conf files and I chose to keep my version of mysql.conf. Despite that, the upgrade process is ...
1
vote
2answers
115 views

MySQL cannot recognize variable on file option

I'm using MySQL 5.6 on Mac OS X 10.8 and trying to configure mysql to log genreral_log into a file. However, it always throws an error when I start it. Here is the .my.cnf file looks like (located at ...
1
vote
1answer
170 views

Using Mysql Replicate to replicate at a particular time

My job has a testing, staging and production enviroment. They want most database changes to be done on the staging environment and for the production environment to replicate the staging environment. ...
0
votes
0answers
55 views

Configuring the mysql server

I have a mysql server installed in RHEL 6 system with 128 GB of Ram and 16 Cores. i am running 4 websites with quite heavy queries having big joins and sortings. Please suggest me a good configuration ...
1
vote
2answers
2k views

mysqld will not start

This is the error I get when attempting to start the mysql server: # mysqld start 130105 8:51:28 [Note] Plugin 'FEDERATED' is disabled. 130105 8:51:28 InnoDB: The InnoDB memory heap is ...
3
votes
1answer
4k views

Can't start MySQL5.5 on Ubuntu 12.04 - “dpkg: dependency problems”

This appears to be a common problem on 12.04. I've tried everthing in this thread including: sudo apt-get clean sudo apt-get autoclean sudo apt-get remove --purge mysql-client-5.5 ...
2
votes
0answers
358 views

Who should I run mysql as, on a personal computer?

I just installed mysql via homebrew (with brew install mysql, on Mac OS X Mountain Lion - recently installed from scratch). Following the installation, there is a "caveats" section with options around ...
0
votes
1answer
222 views

Why does rsnapshot not back up /var/lib/mysql/*?

In rsnapshot's config file I added /var/lib/mysql/ as another source directory to back up. But rsnapshot does not back it up. Why? /var/log/rsnapshot does not list a relevant warning. The owner of ...
3
votes
3answers
977 views

\G like vertical output in MySQL Workbench for show engine innodb status

show engine innodb status; is unusable in MySQL Workbench, as shown here: =====================================120329 12:39:32 INNODB MONITOR OUTPUT=====================================Per second ...
0
votes
2answers
3k views

Mysql stopped working

Mysql is up and running on my system but i can not login with any user. I also cannot start/stop/status the server. All i got is: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using ...
4
votes
2answers
13k views

Can't connect to MySQL server on 'localhost' (10061), but can via PHP

With WAMP 2.2 serving Apache 2.2.21, MySQL 5.5.16 and PHP 5.3.8 on my Windows XP development machine, I can connect and manage my database via phpMyAdmin or any locally hosted PHP script using a DNS ...
1
vote
1answer
69 views

How to retrieve all MySQL settings?

I have a configured MySQL server (MySQL 5.1.47-community) that works perfect. I installed a second server (MySQL 5.5.15-community) to see if the new version of MySQL would work with my application ...
0
votes
1answer
73 views

Alternate installer for MySQL v5.5?

I tried to install MySQL v5.5 on my PC, but it won't install on my machine. Is there another installer that contains MySQL v5.5 that I can try, preferably not the official one from ...
8
votes
9answers
21k views

Configuring a MySQL 5.1 Instance on Windows 7 Professional x64 Fails

I'm trying to set up my laptops to function as mobile development environments. Installing the software on my Linux machine and getting it configured was fairly straightforward, however I'm having ...