Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

67
votes
11answers
7k views

What's the easiest way to set up a LAMP stack?

I set up a new VPS instance of Ubuntu and am wondering what the easiest way is to get up and running with a basic LAMP stack (i.e. which packages are required, which configuration options need to be ...
37
votes
10answers
60k views

MySQL GUI Tools

Does anyone have any good ideas as to native MySQL GUI clients for Ubuntu? So far I've tried MySQL Workbench, which never seemed to work properly, phpMyAdmin which I found a bit slow, and Navicat ...
29
votes
4answers
194k views

How do I start/stop mysql server?

I try find in internet some article where describe how correct start -stop mysql server. I find this article: How to start/stop MySql server on Ubuntu 8.04 | Abhi's Blogging World I run this ...
27
votes
11answers
77k views

MySQL fails to start (After upgrade, installation, etc..)

I'm a newbie on MySQL ground so bear with me. I've just finished upgrading 11.10 to 12.04. Everything seemed to work without any hiccups and all my software and settings are working fine. Apart from ...
24
votes
5answers
25k views

how to stop apache2, mysql from starting automatically as computer starts?

my os is 11.04. i have apache2 & mysql installed. how to stop apache2, mysql from starting automatically as computer starts?
23
votes
6answers
42k views

Where are mysql-admin and query-browser?

In terminal I run next commands: sudo apt-get install mysql-server sudo apt-get install mysql-admin sudo apt-get install mysql-query-browser With first command - all ok. But for latest two ...
19
votes
14answers
33k views

Can't start mysql - mysql respawning too fast, stopped

Today I did a fresh install of ubuntu 12.04 and went about setting up my local development environment. I installed mysql and edited /etc/mysql/my.cnf to optimise InnoDB but when I try to restart ...
19
votes
7answers
34k views

How to install MySQL 5.6?

EDIT #2 Per oerdnj's answer below, I was able to successfully perform an unattended install of MySQL 5.6 on a 64-bit raring system using the following script: dpkg -s mysql-client >/dev/null ...
19
votes
3answers
22k views

How to keep apache and mysql from starting automatically

Is there a way to make apache and mysql not run automatically on startup? Currently, whenever I boot my machine, they start automatically and run in the background. I am using Ubuntu 12.04.
19
votes
4answers
18k views

How to I move MySQL data files onto different partition?

I have my hard drive partitioned with two partitions, so I can easily re-install Ubuntu and try out different versions without losing my home directory data. It is setup like this: 20GB -> / ...
18
votes
3answers
28k views

Moving MySQL datadir

I am trying to move the data directory of my MySQL database to a second disk array that I have as a mount point /array2/. The problem I am having is I have tried everything and after I modify the ...
17
votes
7answers
47k views

How to install MySQL workbench?

Installing MySQL workbench on 10.04 or 10.10 is not a problem, as the deb packages are available on MySQL's website. But there is no 11.04 deb package available. So, how do I install MySQL workbench ...
16
votes
4answers
126k views

How to change root password for mysql and phpmyadmin

I've set up mysql and phpmyadmin and chose not to set a password when installing hoping that once set up i could login with root and no password but i get the following error from phpmyadmin: Login ...
14
votes
2answers
16k views

My MySQL installation is broken. How to completely reconfigure it?

Here are the following commands I have done. $ sudo service mysql start mysql start/running $ mysql -u root ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
12
votes
7answers
32k views

How do I upgrade MySQL to 5.5, am I best off waiting for it to be available through apt-get?

How would I go about upgrading MySQL to version 5.5 on Ubuntu Server 9.10? Would I be better off waiting for it to be an easy $ sudo apt-get install mysql-server job? I'm also unsure as to which ...
12
votes
3answers
6k views

How do I install MySQL without a password prompt?

I'm trying to install MySQL on Ubuntu Natty without the password prompt. However, I keep getting prompted for a password at some stage after the main installation. Also, when I do enter what I ...
11
votes
4answers
3k views

OpenSource Document Management

I'm looking for Web-based, Opensource, PHP-MySQL Document Managment for my organization with these features: Features : Full text searching Document Metadata User access previledges Document ...
10
votes
4answers
6k views

Install Apache, Php, Mysql latest versions not available via apt

I need to install the latest versions of apache, php and mysql that are available on their websites, but the problem is that apt repositories don't have these updates versions yet. Versions that I ...
10
votes
3answers
7k views

MySQL 5.5 starts and then instantly stops

MySQL 5.5 on Ubuntu 10.10 used to work well until yesterday but today whenever I start MySQL using mysqld_safe as root user it shows Starting mysqld daemon with databases from /var/lib/mysql and ...
9
votes
1answer
7k views

how do I stop automysqlbackup throwing LOCK TABLES error?

How to stop automysqlbackup's cron.daily script -- as installed and configured from apt-get install automysqlbackup -- throwing the following error: mysqldump: Got error: 1142: SELECT,LOCK TABL ...
8
votes
9answers
6k views

mysql-workbench only shows splash screen when being launched

I've downloaded mysql-workbench 5.2.35 and installed it, but when i run it, it shows only the splash screen, nothing more.
8
votes
2answers
5k views

Different locations for MySQL databases?

Can I configure MySQL to store a specific database in a separate place on disk? I still want any new databases to go to the default location, but there's a specific database that I'd like to have ...
8
votes
1answer
3k views

Can I share MySql database files with Windows on dual boot?

I'd like to use in both Ubuntu and Windows (dual boot) my MySql database files residing on a NTFS partition. Will it work? Any gotchas?
7
votes
3answers
17k views

how to reinstall mysql?

A software upgrade broke, among other things, mysql and I have not been able to get it back up yet. Suspected cause: I had a near-full boot disk; the upgrade filled up the disk before completing and ...
7
votes
5answers
66k views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have mailserver configure using dovecot+postfix+mysql and it was runnig fine in the server(Ubuntu Server). But during last week it stopped working correctly. It doesn't send email. When I try to ...
7
votes
3answers
611 views

What to install for mysql?

I am going to learn mysql by myself, so I would like to install mysql on . But there are many applications related to mysql in synaptics. I was wondering what are some basic applications to be ...
7
votes
1answer
222 views

How disable mysql command in sudoers file?

How can I disable /usr/bin/mysql command in sudoers file? I've tried to use it this way: %tailonly ALL=!/usr/bin/mysql But when I access user 'tailonly' of group 'tailonly', this command is still ...
7
votes
4answers
21k views

How to configure phpMyAdmin to access multiple servers?

What is the Ubuntu way to configure phpMyAdmin so that I can use it to administer multiple MySQL servers? The database parameters are set in /etc/dbconfig-common/phpmyadmin.conf, but there's only ...
6
votes
9answers
11k views

Are there any GUIs for Mysql? What is recommended? [duplicate]

Possible Duplicate: MySQL GUI Tools I am looking for a mysql GUI for ubuntu 11.04. I am looking for one with a feature set comparable to sqlyog for windows. Does anyone have any ...
6
votes
5answers
10k views

What is a good MySQL manager?

On Windows, I use SQLyog. And I am new to Ubuntu. Is there a mysql manager programs as good as SQLyog ?
6
votes
2answers
13k views

Remove services from upstart

I have mysql installed (from repos) on a development machine (laptop) and I don't need the daemon running on every boot. I've copied /etc/init/mysql.conf to /etc/init/mysql.conf.old and then removed ...
6
votes
1answer
980 views

If I reinstall mysql do I lose my databases?

I have MySQL installed on my localhost. What happens if I have a problem with mysql and I want to re-install it again? Do I lose my existing databases?
6
votes
2answers
5k views

mysql doesn't update due to error in apparmor profile

I got a mysql error after the update of it. This is the log. (Leyendo la base de datos ... 559752 ficheros o directorios instalados actualmente.) Desinstalando mysql-server ... Configurando ...
6
votes
2answers
1k views

How to access MySql on Windows from Ubuntu?

Is it possible to have the actual MySQL database installed on Windows and access it from Ubuntu 10.10 on the local network? I think I need a MySQL "client" ? So I looked here (MySQL Linux0Generic), ...
6
votes
1answer
4k views

How do I set up Mysql Cluster?

I am trying to setup mysql-cluster-gpl-7.1.17-linux-i686-glibc23.tar.gz on ubuntu 10.04 server for the past 3 weeks and not successful yet. The links I followed are: ...
6
votes
1answer
5k views

How can I export MySQL database manually - without phpmyadmin [closed]

My phpmyadmin doesn't work, i see only white blank page when i open it(it's has some issue), However, I'd like to export my project databased manually to another computer. i saw all my databases ...
6
votes
1answer
2k views

why would /etc/init.d/mysql run the wrong upstart job?

update: /lib/init/upstart-job has been replaced with the MongoDB init script. For some reason, /etc/init.d/mysql start|stop|restart|status (/etc/init.d/mysql is simply a symlink to ...
5
votes
1answer
9k views

How do I enable the mod_rewrite Apache module for Ubuntu 11.04?

In other linux like CentOS, it works but i am not getting it running in Ubuntu 11.04. /var/www/html/folder/public/.htaccess: Invalid command 'RewriteEngine', perhaps misspelled or defined by a module ...
5
votes
2answers
5k views

MySQL server Upstart script not working on boot

For some reason the Upstart script for the MySQL server isn't working when I boot my server, however it does work once the server has booted and I execute sudo start mysql manually. I'm running an ...
5
votes
4answers
3k views

Enabling SSL in MySQL

I'm running Ubuntu Server 12.04, and I want to enable SSL connections to MySQL. I've generated the following keys/certs files with OpenSSL: ca-cert.pem server-cert.pem server-key.pem I stored ...
5
votes
1answer
6k views

MySQL server not accessible from remote machine

I have installed MySQL server in my local Ubuntu server (11.10). I can't connect to the server from a remote machine. When I tried:- nmap localhost , It shows the following PORT STATE SERVICE ...
5
votes
2answers
3k views

Can't log to mySQL

Even after I reset root password with following command I can not log to mySQL: (other command listed to provide additional info) # sudo dpkg-reconfigure mysql-server-5.1 # mysql -u root -p ...
5
votes
3answers
894 views

Which is the easiest way to reset the mysql root password?

In the past there has been sudo /etc/init.d/mysql reset-password, (1) is manually restarting and setting the password with an sql command again required? (2) (1) ...
5
votes
1answer
4k views

Where are the MySQL InnoDB log files stored?

I changed some settings for my InnoDB tables in MySQL and encountered the problem that InnoDB was not shown in SHOW ENGINES output. As an answer I got the suggestion to delete the log files of InnoDB. ...
5
votes
2answers
2k views

PHP and MySQL not communicating

I have come to the conclusion that my PHP installation and my MySQL installation are not getting along; I’m working on making my first web page that uses MySQL for content, but after two days, man ...
5
votes
1answer
482 views

File access: open fails for one program but not another

This is the most unusual thing. I'm trying to start up mysqld with a different my.cnf (so I can have two MySQL daemons running without conflict). The file is /etc/mysql/my2.cnf but mysql won't open ...
5
votes
2answers
13k views

Cannot install mysql-server (5.5.22) on clean ubuntu 12.04 LTS server

I have a clean minimal install of Ubuntu 12.04 LTS server 64-bit (just a root user and nothing alse installed). I tried to install the mysql-server with the following command: apt-get install ...
4
votes
2answers
233 views

What is the differences between mysql-client and mysql-client-core?

I wonder what is the differences between mysql-client and mysql-client-core? Also there are mysql-server and mysql-server-core.
4
votes
5answers
3k views

How to stop mysql from running at boot time?

How could I stop Mysql from running at boot time? Is there any GUI for that or this must be done through console? It's Ubuntu 10.10
4
votes
4answers
14k views

“Can't connect to local MySQL server through” socket error [duplicate]

I install mysql and try start /usr/local/mysql/bin# ./mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) /usr/local/mysql/bin# Any Idea?