Tagged Questions

Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

2
votes
1answer
976 views

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 ...
0
votes
0answers
186 views

Getting error on my Ubuntu 13.10 “libsnmp15 (>= 5.4.3~dfsg)”

I am going to install Zabbix (Server Monitoring tool) on my Ubuntu 13.10 server, but while installing it getting error like this, zabbix-server-mysql : Depends: libsnmp15 (>= 5.4.3~dfsg) but it ...
15
votes
8answers
23k 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 ...
1
vote
1answer
2k views

Install MySQL in Ubuntu for XAMPP in 14.04

I was having problem since some time using XAMPP. In terminal the MySQL starts as normal but when it comes to app, it saying MySQL stopped working. So I removed MySQL and hope installing it again will ...
0
votes
0answers
297 views

MySQL JDBC Connection using Eclipse

I have now read numerous installation guides and spent a few days reading in different forums, but I cannot get my program to find the class com.mysql.jdbc.Driver The current status is: I have added ...
0
votes
0answers
191 views

Ubuntu 12.04 server: Problem with apache internal processes using too much memory?

I've looked around and couldn't find an answer for this, tried quite a few of other people's solutions over the months, but nothing fixes this. I run 12.04 on a good VPS, but I've been having some ...
2
votes
1answer
184 views

MySQL import never completing

I wrote a bash script, and here is my problem. The script run for hours, and it never completes. I see the MySQL import process finish, but the script never gets any further. I have tried adding an ...
6
votes
3answers
8k 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 ...
3
votes
1answer
7k views

MySql Workbench on Ubuntu 14

Hi I just installed the newest version of Ubuntu, 14, and now I need to install MySql Workbench. I download the .deb package from mysql site but when I try to install it I obtain this error: ...
0
votes
0answers
364 views

mysql-server won't update and won't start

Whenever I update, I get errors in mysql configuration: start: Job failed to start invoke-rc.d: initscript mysql, action "start" failed. No apport report written because the error message indicates ...
0
votes
1answer
727 views

Unable to uninstall MySQL 5.6.17 from Ubuntu 12.04

I installed MySQL 5.6.17 using binary file *.tar.gz. I need to remove MySQL from my Ubuntu system. I tried running the following commands: 1) sudo apt-get remove --purge mysql-server mysql-client ...
0
votes
1answer
49 views

Two servers using the same database files

Because I do often work out of the office I have implemented a provision mechanism with the a local server, so I have a "server" running on my laptop and one on my computer office. All my files are ...
0
votes
0answers
17 views

add remote server for phpmyadmin

After I install phpmyadmin that I can access local MySQL server, but I would like to add a remote MySQL on Windows. I can not add remote server from phpmyadmin. Are there any configuration files to ...
1
vote
1answer
63 views

Symbolic Link Error with MySQL Cluster and Ubuntu 12.04

I want to install MySQL Cluster on Ubuntu and I followed this tutorial Install MySQL Cluster on Ubuntu 12.04 LTS. My management node installed successfully, but I am having a problem in my database ...
1
vote
2answers
5k views

mysql server start failed

I am running ubuntu server. When I tried to login to mysql(which was running),I got the following error ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
0answers
70 views

Install MySQL Workbench without installing MySQL (i.e. alongside Percona)

I have percona server and client installed locally and I would like to install MySQL Workbench as well. However, whenever I attempt to install MySQL Workbench, it tries to remove percona (and vice ...
0
votes
1answer
204 views

Broken dependencies while installing redmine using apt on fresh 14.04 [duplicate]

On vanilla 14.04: run aptitude chose package redmine see broken conflicting package problem (something with ruby-rack) How can I deal with it?
0
votes
1answer
23 views

Missing header files when installing

I am trying to install Mysql-5.5 directly through Terminal but I get an header files is missingerror and it fails to install. The problem stays when I run sudo apt-get update/upgrade Is ther any way ...
1
vote
1answer
61 views

mysql server admin error from workbench

I installed MySQL Workbench and would like to create a new server instance to admin the server, but I got following error message when I create a instance for local server. Operation failed: File ...
0
votes
3answers
1k views

installing XAMPP error

I followed these instructions: http://ubuntuportal.com/2013/12/how-to-install-xampp-1-8-3-for-linux-in-ubuntu-desktop.html I already installed lampp in to my directory files under the opt. I am ...
0
votes
1answer
60 views

Access MySQL and PHP after installation

After I installed Apache2, MySQL, MySQL Client, phpMyAdmin and PHP on my Ubuntu 13.10, I tested the Apache2 using 127.0.0.1 and it works. I would like to learn how I can access MySQL and create PHP ...
0
votes
1answer
45 views

How can I install the MySQL client? [duplicate]

I installed mysql server and want to install the mysql client using following code: apt-get install mysql-client but I got following error message: E: Could not open lock file /var/lib/dpkg/lock - ...
1
vote
2answers
4k views

Shell script issue: cron job script to Restart MySQL server when it stops accidentally

I have this script, I am using it to setup CRON job to execute this script, so it can check if MySQL service is running; if not then it restart the MySQL service: #!/bin/bash service mysql status| ...
0
votes
1answer
248 views

Restoring MySQL files to new disk 14.04 - permissions?

I am rebuilding my computer with a new disk and have a backup of my MySQL db's - I have moved them to /var/lib/mysql and when I try: sudo /etc/init.d/mysql start MySQL refuses to start - the error ...
0
votes
1answer
2k views

Mysql on Ubuntu 14.04 problem with AppArmor permissions for data directory

I've been using MySQL with a different location for the database date since Ubuntu 12.04 and had no problems. My configuration was like this: Data in /home/db/mysql Link in the default location sudo ...
4
votes
2answers
1k views

What is the differences between mysql-client and mysql-client-core?

I wonder what is the differences between mysql-client and mysql-client-core? Also there are mysql-server and mysql-server-core.
0
votes
0answers
148 views

How to get write permission on /etc/environment?

I want to add mysql Connector jar file to classpath and by browsing through the net. I read that a global way to do it is to update the /etc/enviroment but the file opens as readonly. What I don't get ...
0
votes
1answer
4k views

Apache shows index of/ instead of default index html [duplicate]

I installed apache2 on my Ubuntu 13.10 and it works without any problems. I can see the default index page (which is located in /var/www/index.html) by typing localhost/ in the address bar Today, ...
0
votes
0answers
19 views

packages have unmet dependencies while installing mysql? [duplicate]

What is I got this error while installing mysql I enter these commands : sudo apt-get install mysql-server sudo apt-get install mysql-client The following packages have unmet dependencies: ...
1
vote
1answer
131 views

Linux-Ubuntu Problem : Cannot find mysql database after connection is made to mysql

I have a war file deployed in webapps folder at /srv/apache-tomcat-7.0.53/webapps/ War name is InIndia.war I have deployed inindiadb.properties in classpath which is /srv/apache-tomcat-7.0.53/lib ...
0
votes
1answer
382 views

Can't get latest PHP or Pear in Ubuntu 12.04 LTS

I'm attempting to install PEAR, and other components.. but getting the following. $ sudo apt-get install php5 libapache2-mod-php5 php5-mysql Reading package lists... Done Building dependency tree ...
0
votes
1answer
53 views

I have installed mysql on ubuntu 13.10, but don't seem to have rights to do anything?

This is possibly a problem that affects lots of users, I have have found similar posts, but none of the solutions have worked for me. I have installed mysql on my ubuntu 13.10, however I do not seem ...
2
votes
1answer
51 views

Start services only when really required

I use my desktop box as dev "server", so I have installed mysql+apache+whatever. This causes boot to last longer, also memory consumption is high since I have all this services running. Does a ...
0
votes
2answers
4k views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I know that some users may say that this is a duplication but seriously I have combed the answers and those on the internet for over half a day and I am so frustrated i am going to explode. Now that ...
1
vote
0answers
218 views

Ubuntu 12.04 problems with mysql

I use Ubuntu Server 12.04 for my Django project. On my local PC there is no errors and etc. Sometimes on server I have error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
2answers
119 views

Apache unable to connect to MySQL

I installed apache server (this story). I cannot connect with remote (I tried local too) mysql server. After a long loading page I get error MySQL database connect failure. Mysql server is far from ...
1
vote
2answers
1k views

Can't connect to local MySQL server through socket '/tmp/mysql_2.sock' during manual installation of mysql

I get the error below when attempting to manually install mysql-5.6.17-linux-glibc2.5-x86_64 Steps I followed: 1. tar -xzvf mysql-standard-5.1.34-linux-i686-glibc23.tar.gz 2. ln -s ...
0
votes
1answer
129 views

Unable to connect - Apache2 in Ubuntu 12.04 VirtualHost

I have followed the tutorial from here https://www.digitalocean.com/community/articles/how-to-set-up-apache-virtual-hosts-on-ubuntu-12-04-lts to set a local website. I just changed the port 80 to ...
0
votes
1answer
33 views

mysql problem with login in terminal

I read many post including https://help.ubuntu.com/community/MysqlPasswordReset this one one all of method. How much time I do this I don't know. Still my problem was't fixed. I already wasted 6 more ...
1
vote
3answers
102 views

Is MySQL still running after uninstall it?

I had mysql server running. I stopped it, and removed it (apt-get remove mysql-server mysql-client) I then manually removed the directories: /var/lib/mysql /var/run/mysqld I rebooted. But when I ...
0
votes
0answers
23 views

mysql user access

I'm trying to move my mysql default database directory. I've found out how to do this, but I need to be able to use mysql, when it's /var/mysql/ directory's owner and group are set to root, not to ...
1
vote
0answers
226 views

Subdirectories Show 404 Not Found on 13.10 web server

I recently set up a web server on Ubuntu 13.10 and when I enter the external IP it works fine showing the index file of var/www/ but whenever I try to add a folder, say one called test, and I go to ...
0
votes
1answer
441 views

mysql error : Incorrect key file for table '/tmp/#sql_5115_0.MYI

Query failed by reason : Incorrect key file for table '/tmp/#sql_5115_0.MYI i read that it may be realted to disk space issue but i ma not sure how that is as df -h returns Filesystem Size ...
3
votes
1answer
145 views

How to transfer MySQL database from Windows to Ubuntu?

I want to transfer my database from WAMP on my local machine to my Ubuntu VPS. Can I just copy the folder of the database from C:\wamp\bin\mysql\mysql5.6.12\data to /var/lib/mysql?
0
votes
0answers
39 views

Ubuntu precise 12.04 init.d issue after installing percona 5.5

First of all, it keeps on starting mysqld_safe even if it is not provided by my my.cnffile. I found this in the init.d script: "${PERCONA_PREFIX}"/bin/mysqld_safe > /dev/null 2>&1 & And ...
-1
votes
1answer
146 views

Managing a corrupted apt-get state [closed]

I'm extremely frustrated with apt-get (and probably dpkg also). At least once or twice per year my apt-get will mess things up on my server which requires a total reinstall of my Debian OS. This ...
0
votes
0answers
526 views

How to solve this - Failed to fetch http: Size mismatch

I'm trying to install MySQL server in Ubuntu 13.04. But, I get the following warning WARNING: The following packages cannot be authenticated! libaio1 mysql-common libmysqlclient18 ...
1
vote
2answers
2k views

how to upgrade phpmyadmin after installing mysql 5.6

After upgrading MySQL from 5.5 to 5.6 I got the following error in phpmyadmin: Your PHP MySQL library version 5.5.33 differs from your MySQL server version 5.6.13. This may cause unpredictable ...
0
votes
0answers
44 views

Running OpenEMR on Microsoft Cloud

We want to run OpenEMR on the MS Cloud platform. We created a VM using Ubuntu. To run OpenEMR, MySQL and Apache or another PHP-capable webserver must be configured. OpenEMR requires a number of ...
0
votes
0answers
38 views

HelloWorld.php display 0 value after download and configure Apache2, PHP and MySQL

I have purchased the Lenovo ThinkPad R400 and currently, I am updating my Ubuntu's version. Before the update from 12.04 to the current version, I have installed Apache2 in my machine including MySQL ...