Ask Ubuntu Stack Exchange
Ask Ubuntu Stack Exchange

Questions tagged [mysql]

Questions regarding the MySQL database server, client and tools.

MySQL is a fast, stable and true multi-user, multi-threaded SQL database server. SQL (Structured Query Language) is the most popular database query language in the world.

Source: Ubuntu package description

Links:

2947 questions
63
votes
7 answers

How do I move the MySQL data directory?

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 location of datadir in my.cnf mysql will not start up…
Jonny Flowers
  • 961
36
votes
8 answers

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).
Ross Smith II
  • 367
28
votes
5 answers

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 -> / (root) 180GB -> /home I do a lot of development…
Stephen RC
  • 4,812
24
votes
5 answers

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/mysqld.sock' (2) $ aptitude search mysql |grep ^i i…
alm
  • 261
24
votes
3 answers

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 ask your server's administrator to enable it. PHP…
user221117
  • 341
  • 1
  • 2
  • 4
23
votes
2 answers

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 script you are attempting to invoke has been…
Karthik
  • 283
  • 1
  • 3
  • 7
21
votes
3 answers

How to completely delete MySQL for clean install

I need to completely delete everything about MySQL. It was not starting so I decided to delete it. However during installation this happened: sta@daPC:~$ sudo apt-get install mysql-server Reading package lists... Done Building dependency tree …
SarpSTA
  • 1,011
17
votes
9 answers

MySQL error: The partition with /var/lib/mysql is too full!

I get this error when trying to start MySQL: The partition with /var/lib/mysql is too full! Here is the output of df -h: Filesystem Size Used Avail Use% Mounted on /dev/sda1 455G 77G 356G 18% / none 4,0K 0 4,0K 0%…
rocketgear
  • 409
  • 1
  • 3
  • 7
15
votes
3 answers

Optimising MySQL settings - mysqld running out of memory

I'm a bit confused about which settings to change in my my.conf file to optimise for my server (the mysql server keeps crashing due to our high traffic). Here's the my.cnf file: [mysqld] user = mysql pid-file =…
babbaggeii
  • 917
13
votes
2 answers

How come I get "mysqld.service failed to load: No such file or directory."

Following this tutorial, I'm getting # sudo service mysqld start Failed to start mysqld.service: Unit mysqld.service failed to load: No such file or directory.
Evan Carroll
  • 7,526
13
votes
2 answers

unable to create database due access denied

I just logged in to Ubuntu 12.04 as a normal user (vivek) and opened the terminal to create a database, I wrote: create database Hello; and the error I had is: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'vivek' If I…
viveksinghggits
  • 245
13
votes
2 answers

Error during mysql-server installation

I was trying re-installing mysql-server, but I am getting some sort of warning during installation. It got installed but it's not working. Setting up mysql-client-core-5.7 (5.7.23-0ubuntu0.18.04.1) ... Setting up mysql-server-core-5.7…
Amit Singh Gaur
  • 141
  • 2
  • 5
11
votes
1 answer

Vi in MySQL for command editing

When using the MySQL command line interface, is there any way to get it to let you use vi command editing keys instead of emacs?
SpashHit
  • 1,456
11
votes
2 answers

Mysql couldn't write to /tmp then failed to restart

I was running orthomcl program which uses mysql. This program has operated just fine on the same computer before. This time I had an error message. DBD::mysql::st execute failed: Can't create/write to file '/tmp/#sql_700_1.MYI' (Errcode: 13) at…
user264649
  • 111
  • 1
  • 1
  • 3
11
votes
1 answer

Tora: No connection provider

I install tora on ubuntu 12.04. When I try to open, I'm unable to connect mysql database. Tora is not showing option for mysql.
vusan
  • 457
1
2 3
…
21 22