Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
14 views

Problem during installing mysql server

I tried to install mysql workbench with Ubuntu software center but It could not install it. Then I used command line to install mysql server and I run the following code repectivly: sudo apt-get ...
30
votes
6answers
35k 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?
0
votes
0answers
6 views

Xubuntu 15.04: Can no longer navigate with Ctrl + left/right on MySQL shell

In previous versions of Ubuntu (and other Linuxes), I was able to jump word-by-word in the MySQL shell with Ctrl+←/Ctrl+→. This does not seem to work in 15.04. Instead I get ;5D (Ctrl+←) and ;5C ...
0
votes
0answers
8 views

What does (mysql-workbench-bin:4022): Gtk-CRITICAL **: gtk_tree_view_unref_tree_helper: assertion 'node != NULL' failed means?

I'am running a Mysql server at my Linux system locally running the Debian version, and I start the server and that's okay. Then I start Mysql Workbench and when I execute the Mysql script, I can see ...
3
votes
3answers
7k 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 ...
0
votes
1answer
4k views

Unable to Login as root after mysql service restart

I installed mysql on Ubuntu 14.04 LTS like: sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql after completely removing mysql with: sudo apt-get remove --purge mysql-server ...
0
votes
0answers
7 views

Error while updating with drush

I have an ubuntu server with apache that is going to be the host of our public web site (the site is using Drupal). We currently have a public web site and are moving that site to a new server. I ...
0
votes
1answer
13 views

mysql 5.5 failing to start [ERROR] Can't read from messagefile '/usr/share/mysql/english/errmsg.sys'

Mysql has been working fine until now. Maybe upgrades and broken it. Running 5.5.43 on 12.04LTS. At first there was the error: /usr/sbin/mysqld: unknown option '--explicit_defaults_for_timestamp' ...
0
votes
0answers
24 views

MySQL can't install after bad remove

Some time ago I wanted to have MySQL on my VirtualMachine and I installed mysql-server-5.6. Something went wrong so some site told me that I had to manually purge packages so I did something like ...
1
vote
3answers
321 views

MySQL breaks after upgrade from Ubuntu 14.04LTS to Ubuntu 15.04

I recently upgraded from Ubuntu 14.04LTS to 15.04 and during this upgrade, MySQL probably broke. After the upgrade, I ran the command(to start mysql): sudo service mysql start The result was command ...
2
votes
1answer
100 views

Systemd Mysql won't stop

After upgrading to 15.04, I have had lots of fun getting to know systemd. I think I have everything working except I am unable to stop mysql.service; the systemctl command just hangs and mysql just ...
4
votes
2answers
11k 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 ...
0
votes
4answers
16k views

how install mysql 5.6 and mysql workbench 6.0.9 on ubuntu 13.10

I am using Ubuntu 13.10 Saucy Salamander (64 bit System) . I want to install mysql 5.6 and workbench 6.0.9 on it. how i do it please describe step by step?
1
vote
1answer
93 views

Ubuntu mysql workbench menu shows doubled

I install mysql-workbench in ubuntu 14.04 LTS software center. It install mysql workbench version 6.0.8. In this, menu is doubled So I decided to upgrade the mysql workbench version and add a ...
0
votes
2answers
4k views

Changes for upload_max_filesize, memory_limit & post_max_size in the php.ini aren't affect

I'm trying to increase the upload_max_filesize etc in order to import bigger files with PHPMyadmin. I have changed the php.ini and restart Apache. I can see the changes on the PHPMyadmin import ...
0
votes
1answer
27 views

ODBC error connecting to MySQL

I wonder if someone could help with an issue I can't seem resolve with ODBC for MySQL. I am reasonably new to Linux, so any assistance that can be offered would be helpful. If it helps, I am running ...
1
vote
2answers
6k views

phpMyAdmin - Display all queries

I have installed a fresh desktop with ubuntu quantal and the following packages versions: MySQL: 5.5.28-0ubuntu0.12.10.1 Apache: 2.2.22 (Ubuntu) phpMyAdmin: 3.4.11.1deb1 I would like ...
2
votes
1answer
65 views

Error Updating MYSQL package

My computer froze and I forgot it was updating in the background so I restarted it. When I rebooted I tried to login (and if I entered the wrong password it said incorrect password), but then the ...
1
vote
0answers
9 views

Unable to get MySQL Utilities (mysqlrpladmin) to work properly under Ubuntu 14.04

I currently have replication running between 1 master and 2 slave servers. When I attempt to run mysqlrpladmin using the "--discover-slaves-login" option and "health" command, it only returns the ...
0
votes
0answers
20 views

Unable to connect to mysql server via terminal

My MySQL server is up and running. But when I try to connect to a DB by typing the command: mysql test I get the following: root@holy-pc:/opt/lampp/htdocs# mysql test mysql: ambiguous ...
3
votes
2answers
3k views

Mysql 5.5 reinstallation 12.04

I had a broken installation of mariadb over mysql 5.5. For hours i have tried to reinstall mysql with the usage of apt-get - tried to purge, remove etc everything mysql related. Uninstalled php ...
0
votes
1answer
3k views

Turn off MySQL --skip-grant -tables

I reset my root mysql password with the following instructions: (Works for Ubuntu as well) http://www.debian-administration.org/articles/442 But now I can't turn off mysqld_safe --skip-grant-tables. ...
1
vote
1answer
17 views

Reset mysql server root password? [duplicate]

I do not care to gain access to any database data, I simply want to reset the root password for the MySQL server on an ubuntu 14.04 LTS vm that I am using for development and testing. Several places ...
0
votes
1answer
37 views

Unable to dump mysql tables to local

I was trying to dump my mysql table using the below command mysqldump --tab=/home/username/Desktop/basic/ --user myusername -p mysql user; But it returned an error saying mysqldump: Got error: 1: ...
0
votes
5answers
3k views

Another MySQL daemon is already running?

root@jose-desktop:~# sudo /opt/lampp/lampp start Starting XAMPP for Linux 1.7.7... XAMPP: Starting Apache... XAMPP: Another MySQL daemon is already running. XAMPP: Starting ProFTPD... XAMPP for Linux ...
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: ...
0
votes
1answer
23 views

tab-completion only works for table names (mysql 5.5 on ubuntu 14.04)

I'm used to having tab-completion for mysql keywords, database names etc in mysql, but in my freshly installed mysql (via 'apt-get install mysql-server') it only works for table names, not database ...
1
vote
1answer
19 views

Ubuntu php and apache development!

I heard that Ubuntu has already available for installation packages as well , confirmed and it really is true , just installed that came with php5.5 , I need php5.2.17 for installation of vBulletin my ...
1
vote
1answer
865 views

Error installing mysql server on Ubuntu 14.04 [duplicate]

I am getting error installing mysql on ubuntu desktop 14.04 ( 64-bit) I used following command sudo apt-get install mysql-server It asked me for password (and verification) and ended on following ...
1
vote
1answer
22 views

MySQL ERROR 13 (HY000) on database creation

The full error is: MySQL ERROR 13 (HY000): Can't get stat of './databasename' (Errcode: 13 - Permission denied) I can't create databases in the mysql shell. I can log in as root just fine and I've ...
-1
votes
0answers
15 views

Integration mysql with elasticsearch aws E2 Ubuntu instance?

I have installed elasticsearch and mysql on aws e2 Ubuntu instance. I have to integrate them can any one help me to integrate mysql and elasticsearch...
0
votes
0answers
227 views

Can't install mysql-server on Server 15.04

I have a fresh VPS at Digital Ocean, imaged with Server 15.04 x64. I'm trying to install mysql-server, but it errors out. Why is this happening? The only system configuration-related thing I did ...
1
vote
1answer
32 views

I can't install mysql on 14.04: “Unable to set password for the MySQL root user”

I have tried the solutions presented in Error installing mysql server on Ubuntu 14.04 but I still can't get it to work. The problem i think is when I install it asks me to set password, but then i ...
0
votes
1answer
39 views

unsure of owncloud mysql password and database

I've recently attempted to make my pc an owncloud server. I attempted to logon on the same machine I am hosting it on. However, I first need to enter a mysql password, database name, etc., and I don't ...
3
votes
1answer
3k views

Unable to re install mysql on Ubuntu 14.04: Dependency problems

Ubuntu Unity 14.04 LTS with all lenses removed, except files. (Hate the dash.) I have a LAMP system for web site development. I want to put all my data files in a particular partition that I can ...
-1
votes
1answer
3k views

How to connect to sql server 2008?

I am using ubuntu 12.04, and i have a microsoft sql server 2008 which is running on a windows server 2008 on port 1433, but windows server 2008 is virtualized it is running on vmware and further this ...
1
vote
0answers
27 views

phpmyadmin: unable to connect to 127.0.0.1

I recently installed LAMPP on Ubuntu 14.04. When I start/restart Apache on terminal it shows [OK] but phpmyadmin says "Can't establish a connection to 127.0.0.1". I have tried solutions provided in ...
0
votes
1answer
21 views

LAMP installation [duplicate]

I am trying to install LAMP server on my Ubuntu 14.10 but i am having a lot of problems: the first time i installed it i tried to run my website locally but i wasn't able to access the database ...
1
vote
0answers
31 views

Can't change open-files-limit for mysql on Ubuntu 14.04

I have a LEMP stack on Ubuntu 14.04 with MariaDB. Mysql is a huge bottleneck for my server. I have tried everything of which I am aware to raise the open files limit for mysql. I have added ...
2
votes
1answer
1k views

Where is mysqldbcompare?

The MySQL docs refer to a utility mysqldbcompare. But it doesn't seem like I have it installed, and when I type mysqldbcompare it doesn't suggest any packages (Ubuntu 12.04). Where can I find this ...
0
votes
1answer
1k views

phpmyadmin not working because i changed permissions and don't know how to change it back

I installed LAMPP and it worked fine, but i somehow managed to change the permission of the folder /opt/lampp/ to 777 by using this command sudo chmod 777 -f /opt/lampp -R My plans was to do: ...
6
votes
7answers
18k 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 ...
0
votes
0answers
117 views

MySql crashes happening daily after ubuntu system updates

I have been having this issue for sometime and have no idea why it happens or how to fix it. I'm a Linux novice so that doesn't help. I have a server running on AWS and s used only for hosting ...
2
votes
1answer
1k views

Create firebird database in specific directory

I want to be able to create a firebird database in a specific directory. I know that the firebird user needs to have r/w/x permissions to the directory where I want to create the db. I created a group ...
2
votes
1answer
156 views

Upgrading MySQL 5.5 to MySQL 5.6 on Ubuntu 14.04 LTS

I have installed my LAMP with the following commands: sudo apt-get update sudo apt-get install apache2 apache2-suexec mysql-server php5-mysql sudo mysql_secure_installation sudo apt-get install php5 ...
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 ...
3
votes
3answers
17k views

The phpMyAdmin configuration storage is not completely configured

I typed apt-get install phpmyadmin and ran into an error saying it cannot connect to mysql (socket issue). It was normal because I forget to install mysql before, so I selected "abort" above all ...
4
votes
2answers
3k 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 ...
5
votes
7answers
13k views

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 ...
0
votes
1answer
24 views

Bash sed to read auth into debconf-set-selections for Vagrant VM

I have a Vagrantfile that uses a bash script to set up a VM. I can't get the script to set a password for MySQL using debconf-set-selections with output from an .auth file. Below is an example of the ...