Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

74
votes
12answers
16k 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 ...
12
votes
7answers
34k 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 ...
28
votes
8answers
53k 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).
30
votes
6answers
36k 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?
44
votes
13answers
117k 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 ...
14
votes
2answers
25k 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
4answers
9k 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 ...
57
votes
10answers
101k 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 ...
9
votes
2answers
11k 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 ...
10
votes
2answers
9k 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 ...
2
votes
2answers
13k views

Fixing broken myslq-server package after upgrade to 12.04

After upgrade to 12.04 mysql server was unable to start. I tried many different things but without any luck. Now when I try to install it, I get: $ sudo apt-get install mysql-server-5.5 Reading ...
26
votes
15answers
48k 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 ...
32
votes
4answers
54k 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 ...
26
votes
7answers
84k 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 ...
6
votes
1answer
17k 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 ...
22
votes
5answers
26k 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 -> / ...
4
votes
1answer
24k views

#1045 Cannot log in to the MySQL server

I am totally new in linux/ubuntu I am trying to setup lamp on my OS, however I've installed apache , php , mysql by following commands: sudo apt-get install apache2 sudo apt-get install php5 sudo ...
5
votes
2answers
14k 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 ...
3
votes
3answers
18k views

phpmyadmin throws a 404 on opening

I have installed php5 and phpMyAdmin from the Ubuntu Software Centre on a fresh install of Ubuntu 13.04. when I enter localhost in my browser the following is displayed: It works! This is the ...
7
votes
1answer
13k 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 ...
4
votes
4answers
9k views

'Unable to set password for the MySQL “root” user' on a Openvz VPS

I'm trying to install mysql server on my Openvz based VPS running Ubuntu 13.04 64bit and i keep getting this error at the install. I tried multiple times and i also re installed the os with no change ...
2
votes
3answers
5k views

Debconf errors when configuring mysql-server

When I try to run sudo apt-get upgrade I get the error below. I also get similar error when running sudo reconfigure postfix, which I relly need to run since outgoing e-mail is not working any more. ...
8
votes
6answers
29k 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 ...
5
votes
4answers
26k 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?
3
votes
3answers
1k views

How to deploy: ubuntu | apache | python | C++ | mysql [closed]

What if you want to make a non trivial web site and/or web service? How to deploy production server Apache with python for frontend and C++ for backend and MySQL for persistance? What glue should ...
0
votes
4answers
4k views

Cannot start XAMPP

When I try to start XAMPP with /opt/lampp/lampp start command it gives me a message like this. Starting XAMPP for Linux 1.7.7... XAMPP: Another web server daemon is already running. XAMPP: ...
1
vote
1answer
1k views

Apache / MySql is not running. What is wrong?

I installed lampp / xampp on my Ubuntu 12.04. After installing, Apache and MySQL were running properly. Now, they're not. Here's what I get when I try to run apache: Command: /etc/init.d/apache2 ...
0
votes
2answers
5k views

MySQL server stopped working after upgrade [duplicate]

Possible Duplicate: Fixing broken myslq-server package after upgrade to 12.04 I upgraded to 12.04 and my MySQL server just stopped working. It throws: ERROR 2002 (HY000): Can't connect to ...
0
votes
0answers
545 views

Upgrade to mySQL 5.5 on Ubuntu 11.04 [duplicate]

Possible Duplicate: How do I upgrade MySQL to 5.5, am I best off waiting for it to be available through apt-get? I've seen that mySQL 5.5 has a lot of innoDB performance enhancements. Is ...
47
votes
8answers
100k 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 ...
31
votes
3answers
41k 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.
24
votes
4answers
233k 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 ...
11
votes
5answers
11k 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 ...
7
votes
2answers
9k 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 ...
12
votes
3answers
16k 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 ...
7
votes
3answers
851 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 ...
4
votes
2answers
5k views

Can't log into MySQL

Even after I reset the root password with the following command I cannot log into MySQL. (Other commands listed to provide additional info.) # sudo dpkg-reconfigure mysql-server-5.1 # mysql ...
3
votes
3answers
8k views

Mysql strange installations problems (logger: command not found)

This problem is really strange, I have tried many ways to solve but nothing worked. My last output was: Reading package lists... Done Building dependency tree Reading state ...
2
votes
2answers
6k views

phpmyadmin 404 error on fresh ubuntu 12.04 install

I regularly set up Virtualbox ubuntu setups to run as local webservers. I have set these up several times and never had an issue. However, something has changed: 1)VB guest additions no longer allow ...
5
votes
3answers
1k 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) ...
3
votes
3answers
48k views

can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' [duplicate]

I just installed appache, MySQL and PHP, suring my installation, I was prompted for a MySQL root user password, but when I start my MySQL, it pops the error, and I just can't seem to find a way around ...
1
vote
1answer
3k views

Install ODBC connector for PostgreSQL on Ubuntu Server 12.04

I try to install the ODBC driver for PostgreSQL on Ubuntu Server 12.04. The purpose is to connect R (which is also running on the Server)to the database. I somehow got stock because I did not find a ...
7
votes
7answers
20k 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 ...
6
votes
2answers
5k 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 ...
4
votes
3answers
10k views

Dependency problem with mysql-server-core-5.5 [closed]

When I start the Ubuntu software centre, it says I cannot do anything until the package catalog is repaired. However, repairing fails. I ran sudo apt-get -f install and found the problem to be: ...
3
votes
2answers
19k views

How to Bind to Static IP address in MySQL

I have an Ubuntu server and I've installed MySQL. How would I use my two physical static IP addresses in my.cnf bind-address -- can I add two IP addresses?
2
votes
6answers
14k views

Upstart can't start MySQL

After an installation of MySQL, I get a few errors and I can't run the MySQL daemon. I've tried uninstalling and reinstalling several times, and I'm not sure what's going on. Here's a snippit of what ...
2
votes
1answer
4k views

Is multiple mysqld processes for 1 mysql server is normal?

I'm not an server administrator, but i would like to know why on the server i have like 10 myslq instances? Is it good or bad? Does it negatively impact speed of my website? Here's screenshot: ...
1
vote
2answers
1k views

MySql - unable to connect as root

I have need to connect to mySql server 5.5 and create database using command line. Ideally it would be using a UI utility but I don't have it. Here is an issue: alex@ubuntu:~$ sudo mysql -u root ...
1
vote
4answers
2k views

How to get MySQL back on Ubuntu 12.04?

The upgrade to Ubuntu 12.04 delete MySQL and I need urgently to get it back. The problem is that I'm getting an error installing it, either with apt-get or aptitude: Errors were encountered while ...