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

learn more… | top users | synonyms

42
votes
4answers
425k 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
34k 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. ...
19
votes
4answers
24k 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 ...
3
votes
3answers
497 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 ...
18
votes
1answer
65k 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 ?
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 ...
20
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?
2
votes
2answers
589 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
379 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
2answers
3k 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 ...
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 ...
0
votes
0answers
43 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] ...
0
votes
2answers
196 views

Linux permissioning issues

I'm trying to create a MySQL table on a different hard drive than the default. I get a permissioning error when MySQL tries to create the file. I think I can boil it down to the following lines of ...
10
votes
2answers
47k views

MySQL InnoDB lost tables but files exist

I have a MySQL InnoDB which has all the database table files, but MySQL doesn't see them, and isn't loading them. The problem happened because I deleted these three files: ibdata1, ib_logfile0 and ...
21
votes
4answers
76k 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
31k 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: ...
6
votes
2answers
4k 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 ...
8
votes
3answers
5k views

Debian - Can't stop MySQL; permissions?

I just tried to upgrade from debian squeeze to unstable by replacing 'squeeze' with 'unstable' in /etc/apt/sources.list. The upgrade went smoothly except for mysql, which failed because it couldn't ...
4
votes
3answers
32k 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 ...
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 ...
3
votes
5answers
10k views

Free Mac OS X MySQL GUI [closed]

I'm looking for a good GUI app like Heidi SQL on windows for mac os x, snow leopard specifically. It can support more DBs than MySQL but needs to at least that. I'd like to be able to manipulate DBs, ...
2
votes
4answers
21k 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
2k views

Initial administrator log in to horde

I have installed horde webmail on my debian wheezy machine using the jessie packages and this guide: https://wiki.debian.org/Horde I have set up a database skeleton in mysql - just created a horde ...
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
438 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
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 ...
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 ...
2
votes
2answers
32k views

http://localhost:8080 is not working on running apacher Server through XAMPP

I am unable to configure a PHP/MySQL/Apache environment on my local machine using XAMPP. In my xampp control panel the Apache and MySQL status is shown as started, but localhost URL is not working. ...
2
votes
4answers
9k views

Can't create a MySQL dump on Windows, fails before password prompt

I'm trying to create a dump of a locally installed MySQL database on my laptop. I am aware of the command: %>mysqldump -u root -p --opt [database name] but I am not able to execute it. I might ...
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
6k views

MySQL can't create pid file: Permission Denied

I'm using MySQL on my macbook pro, which worked fine for the last 2 years. A week ago it suddenly stopped and I'm not able to restart it again. I've changed the permission on /usr/local/mysql to 0777 ...
1
vote
1answer
989 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
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
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
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
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 ...
1
vote
1answer
696 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 ...
0
votes
2answers
201 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
1answer
170 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
3answers
472 views

Trovebox (OpenPhoto) setup hangs/fails at final step 3

I've been following the install instructions found here about how to install and configure Trovebox on a Ubuntu server running Apache: Ubuntu 14.04 LTS Apache: 2.4.7 MySQL: 5.5.37 PHP: 5.5.9 ...
0
votes
5answers
570 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 ...
0
votes
1answer
60 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
2answers
3k views

How to access local mysql server from the internet

I configured a router R1 to work as a repeater, I connected an internet router R2 from an ISP to it (R1). The internet router R2 was assigned a static IP (41.58.163.84) by the ISP. I run an intranet ...