Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

108
votes
4answers
728k 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 ...
92
votes
10answers
221k views

Mcrypt extension is missing in 14.04 server for mysql

The php mcrypt extension on ubuntu 14.04 shows that it is installed properly, but phpmyadmin says: The mcrypt extension is missing. Please check your PHP configuration. My current php config is ...
84
votes
14answers
27k 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 ...
74
votes
9answers
141k 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 ...
53
votes
14answers
126k views

“Failed to spawn mysql main process: unable to execute: No such file or directory”

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 ...
42
votes
5answers
81k 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 ...
41
votes
3answers
52k 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.
36
votes
6answers
41k 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?
34
votes
8answers
72k views

How to install MySQL 5.6?

I just installed Ubuntu 12.10 (amd64), and want to install a recent version of MySQL 5.6. If possible, I would like to install (not upgrade) it the "Debian Way' (i.e., using apt-get or dpkg).
32
votes
7answers
129k 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 ...
30
votes
3answers
345k 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 ...
30
votes
15answers
61k 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 ...
30
votes
6answers
67k 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 ...
29
votes
5answers
13k views

16.04 upgrade broke mysql-server

My overall upgrade went well, but I am left with a critically lingering issue of mysql-server not being able to install itself, and nothing I am trying gets it to work. This is the error I see when ...
28
votes
3answers
257k views

ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no )

I'm trying to install queXS cati app on my Ubuntu desktop and I installed MySQL server and PHP 5 and I cannot login into MySQL server as root without password: mysql -u root it says ERROR 1045(...
25
votes
6answers
31k views

Why did installation of MySQL 5.6 on Ubuntu 14.04 fail?

I wanted to get a look at MySQL 5.6 on Ubuntu 14.04 just out of curiosity. And based on this article it certainly looked like installation should be simple and straightforward. So I fired up an AWS ...
25
votes
5answers
34k 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 -> / (...
22
votes
3answers
21k 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 ...
19
votes
7answers
45k views

Where is my phpMyAdmin installation?

I just finished installing mysql-server, and then installed phpmyadmin which came with Apache and PHP. It set it up alright and made a phpMyAdmin database, but I can't seem to find the URL to get to ...
17
votes
6answers
24k views

How to stop mysql from running at boot time?

Currently, my MySQL server starts on every server boot. For a couple reasons, this is undesirable behavior. Is there a way (on Ubuntu 10.10) to disable this behavior?
17
votes
4answers
80k 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 ...
17
votes
5answers
19k 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 ...
16
votes
1answer
15k 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 ...
15
votes
4answers
53k views

Port 3306 appears to be closed on my Ubuntu server

I have two VPS servers, and both have MySQL installed, one for testing and one for development. One of my servers won't let me connect from outside. With the user; 'mytestuser'@'%' According ...
15
votes
1answer
15k views

Start MySQL on Startup

I installed MySQL, and changed the configuration so the databases are stored on a separate hard drive. In the process MySQL has stopped starting up automatically. When I start the computer, I need to ...
15
votes
5answers
27k 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 ...
14
votes
1answer
39k 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 ...
14
votes
2answers
24k views

“Rejected send message, 1 matched rules; type=”method_call“, sender=”:1.5“” while starting MySQL

I have a mysql that has been working fine but now will not start. All I've been able to accomplish is using sudo start mysql which generates the following error: start: Rejected send message, 1 ...
14
votes
2answers
37k views

Mysql Job failed to start

I got an error while am up starting the mysql service. /etc/init.d/mysql start Rather than invoking init scripts through /etc/init.d, use the service(8) utility, e.g. service mysql start Since the ...
14
votes
3answers
38k 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 '/var/run/mysqld/...
13
votes
3answers
24k views

unable to reset root password of mysql

I need to reset the root password of my local mysql installation but it woudln't let me. I've tried this: $ sudo /etc/init.d/mysql stop * Stopping MySQL database server mysqld ...
13
votes
7answers
45k views

Unable to set password for the mysql “root” user

I am new to Ubuntu. I am running Ubuntu 12.10. I am trying to install apache,php,mysql. However I have installed apache and it is running perfectly. sudo apt-get install apache2 But when I tried to ...
13
votes
2answers
13k 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 ...
13
votes
2answers
10k views

How to Drop-In replace MySQL with MariaDB?

I already have several MySQL DBs running on my Ubuntu 14.04 Server, and I would like to migrate these as smoothly as possible to the compatible MariaDB. I'm also using PHPMyAdmin. Is there a different ...
12
votes
2answers
39k views

Cannot install mysql-server-5.5/the following packages have unmet dependicies

I'm a newbie here so please bear with me. I'm using ubuntu 14.04. I tried entering mysql with the following command: mysql -u root -p and I got the following message: The program mysql can be ...
12
votes
7answers
35k 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
16k views

MySQL can't open files after updating server: errno: 24

Ubuntu: 12.04 LTS (Linux mysql02 3.2.0-40-generic #64-Ubuntu SMP Mon Mar 25 21:22:10 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux) MySQL: Ubuntu distro 5.5.31 Apparmor: REMOVED! Server has been running ...
12
votes
2answers
10k 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?
12
votes
4answers
6k 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 ...
11
votes
8answers
13k views

phpmyadmin not working due to missing extensions

I am about to use phpmyadmin on Ubuntu 16.04. But it shows that the page is not working. the error log says error 500 PHP Fatal error: require_once(): Failed opening required '/usr/share/php/php-...
11
votes
4answers
11k 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 ...
11
votes
5answers
57k views

How do I start the MySQL console in XAMPP?

The XAMPP installation is done. XAMPP is up and running. What about the MySQL console? How is possible to start the MySQL console to run some special SQL statements?
11
votes
1answer
7k views

Package upgrade hangs forever on mysql-apt-configure [closed]

Yesterday it got stuck with an update for MySql. The mysql-apt-config didn't finish for ours so I had to shut down the machine in the end. Today it suggested the same update again, but told me that I ...
10
votes
7answers
25k 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 ?
10
votes
6answers
32k views

dpkg: invoke-rc.d: initscript mysql, action “start” failed

I have read a number of the posts here and they all state to run the following commands: Apt-get -f remove ** apt-get update apt-get upgrade apt-get -f install ** I have seen these in various ...
10
votes
1answer
83k views

How do I install and enable pdo_mysql and gd extensions for php5?

When trying to install webtrees I get the following output: Checking server configuration PHP extension "pdo_mysql" is disabled. You cannot install webtrees until this is enabled. Please ...
10
votes
2answers
8k views

Install MySql 5.6 on Ubuntu 16.04

It seems that Ubuntu 16.04 is coming with MySQL 5.7, however I need to install 5.6. When I try to install it explicitly sudo apt-get install mysql-server-5.6 I get the following error: Package mysql-...
10
votes
2answers
4k 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?
9
votes
1answer
24k views

Upgrade MySQL server issue [duplicate]

I failed to upgrade MySQL server. Here's what I tried: I first issue this command to update the package list: sudo apt-get update Then, upgrade by: sudo apt-get upgrade It shows the following ...
9
votes
6answers
80k views

how to correctly install apache2, php5, mysql and phpmyadmin

What is the most correct method of installing apache 2 server, php5, mysql and phpMyAdmin? I installed it this week, and I had a lot problems without solutions, so now that I reinstalled Ubuntu 13.04 ...