Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
31 views

Problem during installing mysql server

I tried to install mysql server and mysql workbench with Ubuntu software center but It could not install them. Then I used command line to install mysql server and I run the following code repectivly: ...
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
9 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 ...
0
votes
0answers
9 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
16 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
26 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 ...
2
votes
1answer
69 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 ...
1
vote
1answer
19 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
1answer
29 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 ...
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
3answers
345 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 ...
1
vote
1answer
23 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
239 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 ...
1
vote
0answers
28 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
22 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
32 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
105 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 ...
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 ...
2
votes
1answer
168 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 ...
1
vote
2answers
1k views

How to get mysql-server setup on Ubuntu 15.04?

When I was upgrading from 14.10 to 15.04 my mysql somehow broke. When I run sudo dpkg --configure -a After a long wait I get the following response Setting up mysql-server-5.6 (5.6.24-0ubuntu2) ...
0
votes
1answer
31 views

Reset password for mysql in ubuntu: [duplicate]

Refer from this question (Resetting forgotten phpmyadmin password) I am trying to reset the password of mysql installed.But run the third command mysql -u root mysql i will get the error ERROR 1045 ...
0
votes
0answers
23 views

MYSQL How to delete and set permissions to root@localhost

I have a problem using mysql, I keep getting this error message for the root user (access denied) : julian@julian-desktop:~$ mysql -u root ERROR 1045 (28000): Access denied for user ...
0
votes
0answers
25 views

Load balancing apache (Linux) with IIS (Windows)

I've got a server (Linux) with Apache2 (2.4.7), Phpmyadmin VSFTPD and Wordpress, a second Linux server with MySQL running alone and a Windows machine with IIS and Wordpress running. I'm looking to try ...
1
vote
1answer
12 views

An error with MySQL

An exception occurred: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) This is what I get when I try to visit one site! The question is: is it releated to my ...
1
vote
1answer
70 views

MySQL broken. Plugin “FEDERATED” is disabled. Plugin “InnoDB” is disabled

I seem to have horribly broken MySQL on our Ubuntu 14.04 LTS server. We recently installed the mysql-proxy package(we've been trying to set up master-master replication, but we've abandoned that for ...
0
votes
1answer
59 views

How to disable autostart for a mysql?

How to disable autostart for a mysql? I was run sudo update-rc.d -f apache2 remove After it I looked throug all rc0.d - rcS.d and nowhere have found a mysql file. However, the mysql server starts ...
0
votes
1answer
46 views

How to remove MySql apt repo

I was trying to install MySql on my system running Ubuntu 14.04. So I added a MySql apt from the link Steps to fresh install MySql After running into a lot of trouble and realizing the apt uses libs ...
0
votes
0answers
34 views

Installing wordpress with remote access

Probably a very easy question to solve, but is there any recent information on how to install wordpress with remote access? I've found a few online but they're all a few years old and giving ...
5
votes
1answer
43 views

How to find the site that crashes the server?

Probably 1 out of 100 sites crashes the VPS every few days. Apache connections go to few hundreds and mysql requests to few millions. That causes the CPU to be at 100%+ permanently and making the ...
1
vote
4answers
95 views

Unmet dependencies unable to fix

I'm running ubuntu 14.04. I cannot use software center to install anything, even a local deb package so I have to rely on Terminal. Recently I was trying to install mysql-server which generated error ...
1
vote
2answers
22 views

how to use mysql with less and -F

I want to use less as a pager for mysql client. I want to add -F to force quit for short outputs. But I can't combine both correctly. root@jupiter:/# mysql -p -u root -h localhost --pager=less -F ...
1
vote
1answer
29 views

unable to excecute mysql from command line

I've installed xampp. I want to use mysql only and i want to use it in command line not in php myadmin. how can i do that? I've installed mysql again with sudo apt-get install mysql....5.5 so I've ...
1
vote
0answers
40 views

Can`t reinstall mysql on kubuntu

Every time I try to install MySQL I get Setup package mysql-client-5.5 (5.5.41-0ubuntu0.14.04.1) … Setup package mysql-server-5.5 (5.5.41-0ubuntu0.14.04.1) … 150415 15:35:15 [ERROR] Can't find ...
0
votes
1answer
55 views

Building ubuntu touch app with sql (mysql) support problem

i`m trying to develop simple ubuntu application. This application should connect to remove mysql server, query and display data in UbuntuListView. Project was created in Qt Creator 3.1.1 as QML app ...
2
votes
1answer
45 views

mysql and do-release-upgrade

Could someone tell me what happens to mysql databases when you run a do-release-upgrade? When I do the dry run for do-release-upgrade I see that it will uninstall mysql client and server and install ...
0
votes
0answers
159 views

http://localhost/phpmyadmin Not found

I have tried to run myphpadmin and I get this message: Not Found The requested URL `/phpmyadmin` was not found on this server. Apache/2.4.10 (Ubuntu) Server at localhost Port 80 I have reinstalled ...
0
votes
3answers
48 views

cant remotely connect to mysql

I've got a 3 servers & 1 windows machine running in a LAN HTTP server (Apache2, PHP5 & phpmyadmin) - 10.0.0.10 DNS - 10.0.0.1 MySQL - 10.0.0.40 Windows - 10.0.0.157 i've just installed a ...
0
votes
1answer
45 views

Can't install phpmyadmin on ubuntu 14.04+apache2

I installed phpmyadmin via sudo apt-get install phpmyadmin but here what gives me http://localhost/phpmyadmin/: php5, phpmyadmin etc. modules are activated for apache. How can I fix this?
0
votes
0answers
96 views

Unable to access phpMyAdmin remotely

I've got a 3 servers & 1 windows machine running in a LAN HTTP server (Apache2, PHP5 & phpmyadmin) - 10.0.0.10 DNS - 10.0.0.1 MySQL - 10.0.0.40 Windows - 10.0.0.157 I'm currently trying to ...
2
votes
2answers
54 views

Automate user creation [closed]

I have a site for my students, and it is running on Ubuntu 14.04. When my students register themselves on my site, I store user info in an MySQL DB. I would like to give my students a website on my ...
0
votes
2answers
118 views

Installing MySQL Workbench ⇒ Error

I have installed MySQL Workbench in the past using MySQL APT. My software repositories lists have recently been updated and since then my MySQL Workbench disappeared. It is still on the disk but it ...
0
votes
0answers
37 views

MySQL service status shown as not running with --status-all

I'm having a problem with my mysql server which does not seem to work properly. On Ubuntu 14.10 I run service --status-all and get [ - ] mysql However, after service mysql status I receive mysql ...
1
vote
1answer
16 views

Mysql failure packages

root@dedi-fr-36189:~# apt-get install mysql-server Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean ...
1
vote
2answers
59 views

Connecting phpmyadmin to seperate mysql server

I've got what's probably a very easy question to solve, but I've been stuck on it for a few days now. I've got 3 servers running in a small network, DNS, HTTP and MySQL. I've got apache2 and PHP5 ...