MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.

learn more… | top users | synonyms

44
votes
4answers
468k views

mysql how to fix Access denied for user 'root'@'localhost'

Before I screw up something, when login using $ mysql -u root -p, and show databases: +--------------------+ | Database | +--------------------+ | information_schema | | mysql |...
31
votes
3answers
35k views

Disable MySQL startup in Ubuntu 10.04

I want to prevent MySQL from starting in Ubuntu 10.04 I have used update-rc.d -f mysql remove and confirmed that there is no link to the /etc/inid.d/mysql script from any of the rc?.d directories. ...
24
votes
2answers
14k views

Symlink error when installing MySQL via Homebrew

Trying to install MySQL via Homebrew. The install seems to work fine but i get an error: "Error: The linking step did not complete successfully The formula built, but is not symlinked into /usr/local ...
19
votes
4answers
25k views

how do I see which user I am logged in as in MySQL?

I have multiple text console session open and log in as different users into different consoles. I forget after while which consoles belong to which user, it would be nice to not have to quit and log ...
21
votes
2answers
12k views

Pipe gunzip and mysql to gunzip a dump and import it

I have a .gz sql dump file (example: foo.sql.gz) that i want import in my database with the classic mysql command. gunzip -c foo.sql.gz > foo.sql mysql -uroot -ppassword foo < foo.sql foo is ...
4
votes
2answers
6k views

Rails: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

So I've got a Ruby on Rails application that I am trying to run (in development) on Snow Leopard. I've got it working on my Ubuntu computer, but now I need to get my Snow Leopard environment set up. ...
4
votes
6answers
1k views

Is MySQL installed by default with OS X Leopard 10.5 or 10.6

If so where can I find the installation?
3
votes
1answer
5k views

MySQL Notifier High Severity Error at startup

When i start MySQL Notifier up and error like this is shown: "High Severity Error" "Object reference not set to an instance of an object." And when i click over "Show Details" I can see the ...
2
votes
2answers
729 views

How to automatically restart MySQL and MongoDB when being unresponsive?

I’m running a simple development server (Ubuntu) on which MySQL and MongoDB sometimes crash. I always restart them with sudo service mysql restart. Although I know I need to investigate why they ...
3
votes
2answers
403 views

Will a query which may take hours to execute keep executing on remote server if I close the connection after executing the command?

If I connect to a remote database server via ssh, start mysql client and execute a query which may take a couple of hours to execute, then close the connection, will the query continue to execute ...
3
votes
2answers
3k views

MySQL localhost connect works but 127.0.0.1 does not

Does anyone know what the error could be when I can connect to my MySQL server via localhost but not via 127.0.0.1? AFAIK, these should be routed identically and no additional TCP layer should be ...
1
vote
1answer
2k views

Can't install MySQL on Mountain Lion

I have clean 10.8 OS X (with Retina MacBook Pro). I have totally the same situation like here Can't re-install MySQL on OS X Leopard after uninstalling and similar with that http://stackoverflow....
0
votes
0answers
64 views

XAMPP and MySQL

Ok so I have this message error in XAMPP: 20:25:37 [mysql] Error: MySQL shutdown unexpectedly. 20:25:37 [mysql] This may be due to a blocked port, missing dependencies, 20:25:37 [mysql] ...
18
votes
1answer
71k views

How to manually install Apache, PHP and MySQL on Windows?

How do I install Apache with PHP support and the MySQL server on Windows without using any ready-to-use packages like WAMPServer or XAMPP ?
21
votes
4answers
77k views

What steps do I need to take to completely uninstall MySQL?

I have installed and uninstalled MySQL Server for about 100 times. Each time I reinstall the thing, it shows the same configurations, which I think cause problems. I would like to get rid of all ...
13
votes
6answers
32k views

systemctl enable differs from systemctl start, how?

I am running an Arch Linux (latest, up-to-date) box, and attempting to get MySQL to start at boot. With the systemd package installed I have systemctl available, and as such I can do things like this: ...
9
votes
3answers
6k views

Can't reset MySQL (MariaDB) root password

Today, I wanted to create a database in PMA. It said: "Cannot log in to the MySQL server". I tried via a terminal, same problem, and it is because my password is wrong. And I can't understand why. I ...
7
votes
2answers
8k views

What does the MySQL “max_allowed_packet” setting actually control?

We've been cleaning up database problems for the last four hours, thanks to a broken mysqldump that wasn't sufficiently erroring out. We were getting these errors: mysqldump: Error 2020: Got packet ...
4
votes
2answers
4k views

launchctl: Dubious ownership on file (skipping) (Mac OS X)

I installed mysql recently and added its start command in my .bash file. But when I tried running the command, that's when I encountered this error: launchctl: Dubious ownership on file (...
4
votes
3answers
36k views

How do I start a MySQL Server in Windows ?

I've installed a MySQL server onto my computer and when I first installed it, it ran automatically, now I've restarted my computer it is no longer running, what file do I need to run to get it back up ...
3
votes
3answers
498 views

How to store the data of mysql on OS X in an encrypted state?

I have mysql 5.1 installed by macports with it's data dir in the default location, which is outside my user directory that's protected by filevault. I'd like to store the data in an encrypted state ...
2
votes
4answers
22k views

WAMP MySQL Service will not start

I did a fresh install of WAMP (v2.1) and it works excep the MySQL isn't starting.... here: and everytime I press "Start/Resume Service", NOTHING happens. I go to my.ini and put in a password.Then ...
1
vote
2answers
2k views

MySQL Workbench not present in MySQL Community RPM for Fedora 21

I have given up trying to find a proper workaround or solution to install MySQL Workbench + MariaDB so I decided to install the official stack provided by MySQL so I enabled their YUM repository using ...
1
vote
1answer
3k views

Why can't I access MySQL server with port forward rule in router?

This is my setup (the relevant parts, anyway): I have port forwarding rules in place (in the Linksys) for all the relevant ports and I've restarted that router multiple times, each time hoping that ...
0
votes
3answers
6k views

Export spreadsheet and import as table into mysql

What's the easiest way to export a table from either MS-Excel or OpenOffice calc and import it into a mysql database, where: The table will be imported as a table in Mysql The headers of the table ...
5
votes
1answer
3k views

I believe I've deleted MySQL root user, how do I recreate it?

I'm running ISPConfig on CentOS and I don't know how, but I don't seem to have a root mysql user. I can stop mysqld with /etc/init.d/mysqld stop Start it again and skip grant tables mysqld_safe --...
4
votes
1answer
452 views

MySQL quiet installation references wrong executable

I am trying to install MySQL 5.5.27 (latest) quietly from the Windows (XP) command line via batch file using the MSI method. Following the directions on the MySQL site, I simply do this: msiexec /i /...
3
votes
3answers
63 views

Why do I need ./ for commands to run on Mountain Lion? [duplicate]

Possible Duplicate: What does “/” , “./”, “../” represent while giving path? Why do I need ./ for commands to run on Mountain Lion? For example, when using mysql I have to type in the ...
3
votes
2answers
2k views

Start MySQL from the command line without losing prompt

I'm on Windows 7. I'm trying to run a .bat file where I stop and start MySQL and run some other commands. However, running "C:\Program Files (x86)\EasyPHP\binaries\mysql\bin\mysqld.exe" results in ...
2
votes
3answers
3k views

Lightweight MySQL Qt GUI frontend for Linux [closed]

I'm looking for a lightweight MySQL Qt4/PyQt4 GUI frontend for Linux. Ideally it will be very similar to sqliteman. I did some google searches but it only finds Java monsters and herds of shareware ...
1
vote
1answer
703 views

MySQL ERROR 1045 Access Denied

I recently installed MySQL on Fedora13. Now, when I try to create a database, it denies me access. I tried resetting the password and it does not recognize my system root. I tried resetting password ...
1
vote
1answer
10k views

How to change mysql port

I'm using wampserver. And suddenly mysql wouldn't work. I checked curports from nirsoft and it has red highlight on it. What does it mean?How do I solve this so that I could use mysql again. I'm ...
1
vote
1answer
1k views

Connecting mysql via 127.0.0.1 instead of localhost

I connected mysql on Mac OS X using this command: mysql -u root -p -h 127.0.0.1 After I logged in, I fired up this command: select user(); and it showed: root@localhost and even wired, I ...
1
vote
2answers
164 views

Installing MySQL on MacOS

I want to install mysql. Big Internet told me that I should do it via MacPorts. I've downloaded MacPort's dmg and it asks me to install XCode which I can buy via App Store. It is ridiculous to pay ...
1
vote
1answer
440 views

Can't re-install MySQL on OS X Leopard after uninstalling

I'm running Leopard (10.5.8) on a Macbook (not Pro) and I had MySQL running ok, but the Preferences pane wasn't working. I thought a fresh install would be a good idea, so I went through the uninstall ...
1
vote
1answer
2k views

mysql doesn't stop on mac os x

I have mysql installed on 10.6 Snow Leopard. The problem is that I cant stop the server. Its running all the time. How can I solve that? I tried to install mysql again, but this didn't solve the ...
0
votes
2answers
478 views

How to have MySQL entitle the machine's root user?

I'm trying to run mysqlcheck. Its failing with: $ sudo su - # mysqlcheck --auto-repair --all-databases mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when ...
0
votes
0answers
126 views

Reinstalling Mysql On Ubuntu 10.10(Stuck with bad repositories)

I recently configured NDB-cluster with mysql and Mysql just crashed ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) tried re-installing mysql-...
0
votes
1answer
156 views

How do I create a shortcut for a find and replace command in vim?

I have a vim (well, sed really) find and replace pattern I use for resetting the AUTO_INCREMENT property in mySQL CREATE TABLE statements: :%s/AUTO_INCREMENT=[0-9]*/AUTO_INCREMENT=1/g I use this ...
0
votes
5answers
637 views

Mysql resolving 127.0.0.1 to hostname

I'm trying to connect to mysql using the command mysql -h 127.0.0.1 It comes up with the error ERROR 1045 (28000): Access denied for user 'root'@'mydomain.com' (using password: NO) Why is 127.0....
0
votes
2answers
1k views

Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

i am working on windows 7 ..i am using xampp . i restarted my computer then after that when open the mysql yog..then it gives me an error error no 2003 can't connect to mysql server on localhost (...
0
votes
1answer
189 views

Mysql remote server with rights to WMI

I just fixed and got my MySQL running on my computer on port forwarded with all the grants. However, when I am enabling remote server Windows asks for user login information for WMI I need to enter ...
0
votes
1answer
632 views

utf8 hebrew on mysql console on debian (via putty on windows)

I have a my sql server running on a debian linux hosted at linode.com some of my data has hebrew characters in it. I am connecting to the server via putty ssh on windows 7. when I run the sql admin ...
0
votes
1answer
62 views

how to add mysql to path global variables [duplicate]

I have recently installed MySQL and am trying to access it through my command prompt by simply typing in MySQL. I believe I need to add it to my PATH globals. How can I do this?
0
votes
1answer
336 views

Testing bandwidth on a single port

At work we are having issues with our till system. The company we use hosts the database centrally on a MySql server and we connect in on the standard port 3306. The problem that we are having is ...