Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

68
votes
11answers
10k 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
33k 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 ...
22
votes
8answers
41k 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).
35
votes
13answers
98k 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 ...
14
votes
2answers
19k 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 ...
28
votes
5answers
29k 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?
41
votes
10answers
76k 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 ...
11
votes
4answers
7k 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 ...
9
votes
2answers
6k 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 ...
22
votes
14answers
37k 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 ...
20
votes
5answers
21k 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 -> / ...
6
votes
1answer
8k 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 ...
2
votes
2answers
6k 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 ...
1
vote
3answers
4k 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. ...
0
votes
3answers
3k 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: ...
2
votes
2answers
11k 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 ...
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
0answers
544 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 ...
16
votes
3answers
160k 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 ...
20
votes
7answers
59k 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 ...
22
votes
3answers
36k 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 ...
7
votes
3answers
719 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
4k 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 ...
2
votes
2answers
5k 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
4answers
5k 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 ...
0
votes
1answer
949 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 ...
5
votes
2answers
3k 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
7k 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
3answers
30k 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 ...
2
votes
3answers
10k 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 ...
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 ...
1
vote
1answer
3k 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: ...
0
votes
0answers
62 views

Running sudo apt-get upgrade gives error [duplicate]

After running sudo apt-get upgrade I got the following error: The following packages have unmet dependencies: gnome-user-guide : Depends: yelp (>= 3) but it is not installed lintian : Depends: ...
0
votes
1answer
178 views

aptitude problem using mariadb repository on Ubuntu 13.10

I installed mariadb 5.5 on my ubuntu laptop like described here: sudo add-apt-repository "deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu $(lsb_release -c -s) main" and it works fine so far, ...
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
2answers
2k views

How can I load xml through mySql?

On Windows (r) I can this statement to load xml data in the database LOAD XML LOCAL INFILE 'c:/users/yourname/desktop/myfile.xml' INTO TABLE MyTable ROWS IDENTIFED BY '<product>' But, I ...
19
votes
3answers
28k 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.
5
votes
5answers
35k views

How to connect and create a database in MySQL?

I want to install MySQL and create a database on it using the following code: sudo apt-get install mysql-server mysqladmin -h localhost -u {username} -p create lrs I get the following message after ...
25
votes
5answers
47k 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 ...
5
votes
1answer
10k 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
7answers
8k 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 ...
7
votes
2answers
6k 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
5answers
5k 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
3
votes
3answers
720 views

Really Broken MySql Setup

I have been having trouble with my MySql setup. This morning it was a working mysql server I added a database and some data with phpMyAdmin then things started to go wrong. I became unable to connect ...
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
5answers
70k 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 ...
6
votes
5answers
12k 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 ?
5
votes
5answers
18k 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 ...
4
votes
4answers
19k 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?