0
votes
3answers
285 views

MySQL access denied error when connecting via SSH tunnel

For months I've been connecting to the MySQL instance running on our local test server through an SSH tunnel without any issues. All of sudden though, with no changes I can think of, the server has ...
0
votes
0answers
65 views

MySQL character-set-server won't take effect

I'm trying to have my MySQL server use UTF8 as the default collation and character set. I am able to set everything except for the character_set_server which always takes 'latin1' as value. I have ...
0
votes
0answers
119 views

Mac OS X ramdisk for tmpdir in mysql error starting mysql

I successfully created a ram disk using: diskutil erasevolume HFS+ "ramdisk" `hdiutil attach -nomount ram://904800` Here are the disks: Chris-Muenchs-MacBook-Air:data cmuench$ df -h Filesystem ...
0
votes
0answers
109 views

MYSQL #1045 error on mac os x 10.9 (with my password)

I was using ubuntu before i have bought my macbook pro. And today i started to use this computer. Now, I did everything to install php, apache and mysql like here: ...
2
votes
1answer
1k views

MySQL: “UPDATE command denied to user ''@'localhost'” [duplicate]

For some reason when I installed MySQL on my machine (a Mac running OS X 10.9) the 'root' MySQL account got messed up and I don't have access to it, but I do have access to the standard MySQL account ...
3
votes
2answers
1k views

Can't start MySQL 5.6 installed via macports on OS X 10.8.5 (new install errno: 13 - Permission denied)

I've been Googling and banging my head against this one for quite a while now. I have not installed MySQL on this system before and just installed version 5.6 via MacPorts and have run sudo ...
0
votes
1answer
444 views

MySQL doesn't start: touch: ./data/mysql/xxx.local.err: No such file or directory

My OS is OS X, I installed MySQL Percona via brew. Error log of MySQL was /usr/local/var/mysql/xxx.local.err. After that I tried to run mysql_install_db and rebooted machine. OK, but now I see see in ...
0
votes
2answers
1k views

MySQL - Access denied for user 'root'@'localhost' (using password: YES)

I'm pulling my hair out trying to decipher why every time I do a fresh install of mysql on OSX and import a database, the minute I restart the mysql instance I'm prompted with the message: Access ...
4
votes
2answers
62 views

What is the effect of adding a user on a MySQL slave?

This is on a Ubuntu 12.04 server running MySQL 5.5 which is slaved to an OS X server running MySQL 5.1 Logrotate has been sending error: error running shared postrotate script for ...
0
votes
1answer
8k views

MySQL server PID file could not be found

I can start mysql fine, /usr/local/mysql/support-files/mysql.server start Starting MySQL SUCCESS! But any mysql action after that I get the error: MySQL server PID file could not be found ...
1
vote
1answer
192 views

Mysqltuner, how to speed up optimize table? [closed]

I used mysql tuner and here are the statistics. The recommendation says to optimize tables. I have 96 GB of memory on the machine. Is there anyway I can speed up the optimization process? The tables ...
-1
votes
1answer
331 views

How do you upgrade the MYSQL version that Mamp Pro uses? [closed]

I'm currently using Mamp Pro for a local dev environment on Mac OSX Mountain Lion. Ideally I'd like to update the version of mysql. How do you upgrade the MYSQL version that Mamp Pro uses?
0
votes
1answer
491 views

How to activate XAMPP's apache and mysql for non-admin account on Mac OSX [closed]

I have Mac systems with os x10.6.8 and above. Installed XAMPP. Is there any way to START xampp's apache and mysql by non-amdin user or group? I searched alot but came up with no solutions. All i ...
-1
votes
1answer
66 views

Who can provide a mysql 4.0 on Mac OS? [closed]

I need a very old version of mysql(4.0.x) on my Mac OS for debugging and I know the file name format is: mysql-standard-4.0.X-apple-darwinX-powerpc.tar.gz I google some download links,but all ...
1
vote
1answer
534 views

Adding data sources for unixODBC/isql on Mac OSX Lion

I have installed unixODBC from source and mysql-odbc connector from .dmg installer on Mac OSX Lion. This was done a while ago, and at that time I successfully installed a data source (let's call it ...
0
votes
1answer
674 views

MySQL on Mac OS X Lion - can't connect over internet

I've installed MySQL on OSX Lion, however I can't connect to the MySQL server via phpMyAdmin (or Sequel Pro). I have a domain with 1and1, and created a sub domain (server.domain.com) and created an A ...
0
votes
1answer
44 views

Troubleshooting reboot of Mac OS X Snow Leopard server running mysql

we are using Mac OS X Snow Leopard server for mysql database, and it reboots once in a while. This happened once every month for the past 3 months. I looked at syslog and dmesg and I don't see any ...
0
votes
2answers
205 views

mySQL 5.5.23 will not start on OSX 10.7.3

I originally installed mySQL on OSX and it started fine. I was able to connect with mySQL workbench and create a database. However, after a reboot mySQL will no longer start. The launch fails ...
1
vote
1answer
786 views

Remove MySQL (from Apple) on OS X Server Lion

I have a Lion Server (upgraded from a Snow Leopard Server), which still has the Apple provided MySQL 5.0 server [mysql Ver 14.12 Distrib 5.0.92, for apple-darwin10.0 (i386)]. Without out rebuilding ...
2
votes
3answers
1k views

mysql performance tuning, write, get db into ram

I am trying to improve the performance of a website by optimizing the Mysql server. In addition to general optimization I have a feeling that some write operations take an unacceptably long time. The ...
1
vote
0answers
223 views

Can't edit an account in MySQL Administrator on OS X

I'm running MySQL 5.5.20 on OS X 10.6.8. Using MySQL Administrator 1.2.12 (the latest) I am unable to edit any accounts. After successfully connecting to the database in MySQL Administrator, I go the ...
1
vote
2answers
537 views

Installing MySQL 5.5.19 with Macports

The MySQL packages currently available on Macports are up to date for branch 5.1, but for 5.5 they are quite old (the latest one available is 5.5.2). Is there some way to install the latest one at ...
1
vote
1answer
156 views

Command: mysql --print-defaults not recognized?

I am trying to set some defaults in my.cnf and when I tried to check MySQL's current defaults I got an error! Using Zend Server CE 5.5 on OSX 10.6.8 And here is the command and subsequent error: ...
0
votes
1answer
138 views

Restoring mysql.bak

My development environment (Mac Lion) just got hosed after I rebooted my system today. I'm not sure what exactly happened, but it's almost as I'd reinstalled the server. My databases are gone and the ...
2
votes
2answers
5k views

Can't create PID file on MySQL server, permission denied

The MySQL server won't start and is reporting the following error: /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/James-Barnhills-Mac-Pro.local.pid' (Errcode: 13) ...
0
votes
1answer
516 views

MAMP MySQL won't start

I uninstalled MAMP completely, downloaded fresh copy of MAMP 2 from the MAMP website, did a clean install. However, when I try to start mysql, I get the following error log 111120 21:37:49 ...
0
votes
1answer
53 views

mac osx web server, connecting to mysql

I'm trying to connect to mysql using the personal webpage on Mac OSX. However, I keep having issues when i do the command... mysql_connect It says my computer name is spiderman, and that local ...
1
vote
2answers
588 views

Terrible mysqld performance after system upgrade

I recently replaced my old Core2duo Mac with 4GB and OS X 10.6.8 with a 4-core i5 with 16GB, an SSD and 10.7.2. The new system is wonderfully fast for everything except mysqld. It's OK with light ...
2
votes
1answer
792 views

Making a multi hop SSH tunnel a mysql server (3-4 hops)

I'm trying to get to a mysql server on a remote network, and to get to it I currently have to do several ssh hops, so I can use the mysql command line interface. I'd really like to do a mulit-hop ...
1
vote
1answer
864 views

How to resolve “Can't connect to local MySQL server through socket” error

I'm trying to install MySQL on OS X. First I tried MacPorts. I followed the instructions in step 3 of https://trac.macports.org/wiki/howto/MAMP, but when I ran mysqladmin5 or mysql5 I get: ERROR ...
1
vote
1answer
177 views

Server hangs on shutdown

I had recently started a server using /startServer.sh and everything was perfect. Suddenly, there was a power failure here and my os shut down. After booting up, when I tried running ./startServer.sh ...
4
votes
2answers
68 views

MySQL Error for Mac OSx

I'm trying to run the mysql command on my mac osx but keep getting the error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I did try researching ...
3
votes
2answers
2k views

MySQL won't start in MAMP server

I had MAMP successfully running in one of the user, but since I have created a new user to separate things between two developers, its throwing tantrums. I am pretty new to Mac itself but managed to ...
0
votes
1answer
135 views

Running Mysql after removing macports etc

I used to use macports.. awhile ago.. I finally for other reasons uninstalled it. Now.. fully gone/cleaned up/nothong of it on the system.. if I download Mysql isntall package.. or try to use ...
0
votes
1answer
104 views

Revert all changes make to Mac OS X web sharing [closed]

I've been messing about with apache2 php and mysql today and I've taken a few wrong turns. I'd rather install XAMPP than try to figure out all the problems. I did a time machine backup a few days ago ...
0
votes
1answer
3k views

phpMyAdmin works, but directly connecting with Sequel Pro does not

I can connect to database with phpMyAdmin, but I cannot connect with Sequel Pro, using the same credentials. The host is mysql50-33.wc2.dfw1.stabletransit.com. When I connect using phpMyAdmin I notice ...
0
votes
1answer
756 views

where can I find mysql_install_db for Mac

I have downloaded mysql-advanced-5.1.46sp1-osx10.6-x86_64.dmg and installed it. I have a custom my.cnf file and no data to begin with. I dont see mysql_install_db any where. How can i install one. ...
0
votes
2answers
292 views

MySQL maxed out memory usage problem

I am currently ingesting millions of rows of data into a MySQL database. I am monitoring the server status locally on my machine using MySQL Workbench. The application is showing that the memory is ...
0
votes
1answer
131 views

MySQL on Ubuntu 1500% slower than on a less powerful Mac, what might be wrong?

I have a very fast 8 core Ubuntu 10.10 64 bit desktop machine with 16GB of memory running MySQL 5.1.41 but something seems to be wrong with the MySQL installation (even though it's an unmodified stock ...
0
votes
1answer
108 views

mac os x server running mysql servererror - services wont start

Mysql server running on Mac OS X the my.cnf file had max_connections = 10000000 client got the error 'max connections reached' restarted server, now it won't start the mysql services bellow is an ...
0
votes
1answer
142 views

Server maxing out at low bandwidth?

I'm running a Mac Mini Server 2.66ghz C2D, 8GB Ram OSX 10.6 Server. I'm running a WordPress 3.1.1 install with Apache/PHP/MySQL, only serving the pages (images come from S3) per page size is 19k. ...
2
votes
2answers
388 views

Why is the mysql client utility not using the port I specify?

I'm trying to use mysql (command line utility) to connect to mysql server through SSH tunnel. The problem is this mysql client won't use my specified port. For example, I ran this: $ mysql -uroot ...
-1
votes
2answers
110 views

upgraded to mac 10.6 - can't configure mysql [closed]

I'm new to mysql and I'm not a programmer. My computer is a Mac that has been upgraded to Snow Leopard. I have successfully installed apache2 and php, and I have downloaded and installed mySQL. ...
1
vote
1answer
218 views

mysql FATAL ERROR: Could not find mysqld

I am trying to reinstall mysql make sudo make install cd /usr/local/mysql sudo ./bin/mysql_install_db --user=mysql <---- I get FATAL ERROR: Could not find mysqld I think I might have ...
0
votes
1answer
37 views

mysql starting and stopping every 10 seconds

Mysql is starting and stopping every 15 seconds on my MAC. In the console it shows /tmp/mysql.sock is Permission denied. What unix command can I run to make sure every folder related to mysql is ...
0
votes
2answers
217 views

Localhost works, but mysql doesn't

I am trying to get localhost working on my machine. I am using Mac OSX Snow Leopard. The http://localhost in the browser works, MAMP shows the servers are running all well, and displays the start ...
0
votes
1answer
268 views

What should go in my my.cnf file

Can't connect to local MySQL server through socket '/tmp/mysql.sock' Followed http://hivelogic.com/articles/compiling-mysql-on-snow-leopard to the T. Log: 110313 20:48:37 mysqld_safe mysqld from ...
0
votes
1answer
698 views

Connecting to SQL Server with PHP on Mac

I'm trying to connect to my local SQL Server 2008 R2 (have also tried it with 2005, same result exactly) with PHP. I'm using PHP 5.1 which still supports php_mssql and mssql_connect(). for some ...
0
votes
1answer
209 views

Mac OS 10.6 and MySQL 5.5.8 Shutdown

I was just wondering, if MySQL is running when you shutdown does the OS shut it down cleanly or does it just kill the process? I Installed via the .DMG image from the MySQL site. Also started it with ...
-1
votes
2answers
496 views

access denied after clean install of mysql with macports [closed]

I installed mysql5 and mysql5-server with macports started service fine but when i did mysqladmin5 -u root -p ping i get Enter password: mysqladmin5: connect to server at 'localhost' failed ...