Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
8 views

Broken dependencies while installing redmine using apt on fresh 14.04

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
0answers
13 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
8 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
2answers
20 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
20 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
16 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 - ...
0
votes
1answer
49 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
13 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
57 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
229 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
11 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
47 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
18 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: ...
0
votes
1answer
14 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
73 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
22 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
24 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
68 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 ...
0
votes
0answers
48 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 ...
-2
votes
0answers
30 views

Help on mail server on Ubuntu 12.04

I'm having problems on getting start a mail server on Ubuntu 12.04. I just try this tutorial for Debian Wheezy, but without sucess... I really need a mail server running with: Postfix, Dovecot, ...
0
votes
2answers
45 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
49 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
23 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
0answers
45 views

Trying to move the MySQL data directory

OS: Ubuntu 12.04 I am trying to move the mysql data directory and log files to separate mounts to make it easier to swap out drives when needed in the future. ##Moving the MySQL data directory sudo ...
0
votes
1answer
18 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 ...
0
votes
3answers
37 views

How can I stop MYSQL server

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
19 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
31 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
27 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 ...
0
votes
0answers
16 views

Shutdown services when terminal is closed

I want is to shutdown apache as soon as I leave the terminal, that's how django and rails web servers work. My terminal is Terminator. I want to do the same thing with apache and MySQL just to be ...
0
votes
0answers
14 views

MYSQL redump from a log.sql all or nothing

MYSQL re dump from a log.sql all or nothing mysql -h "$databaseHost" -u "$username" --password="$password" "$databaseName" < /path/to/project/log.sql if this log.sql file contains an error in ...
3
votes
1answer
25 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
23 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
35 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
39 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 ...
0
votes
1answer
65 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
14 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
23 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 ...
1
vote
1answer
42 views

How to install mysql without root access?

I found this article that explains how to install MySQL without root access. However, on the MySQL download page is no download link for Ubuntu. Which one should I choose in this case? If it has a ...
1
vote
2answers
142 views

Cannot start mysql server [closed]

I'm tring to run a website from my server, so I installed php, apache and mysql. I'm having problems with mysql. After installation, it failed to restart. This is the output: ...
3
votes
1answer
31 views

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 ...
1
vote
0answers
53 views

MySQL not starting because “mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)”

I am setting up a new LAMP server with Ubuntu Server 13.10 and MySQL 5.5 and was in the middle of migrating mysql databases to new server when I realized mysql server is not running. All was fine last ...
0
votes
0answers
21 views

MySQLdb on Brython?

Hi there I'm working on a server-based point of sale for a sports club, and downloaded Mysqldb lib so that I can access and modify it through python scripts, they work great!, so I decided to use ...
0
votes
1answer
10 views

target 'php5-mysql' is not a directory error

I'm trying to get LAMP up and running in VirtualBox for an assignment I have. I've installed Ubuntu and then Apache 2 and PHP 5. I'm using the instructions found here: ...
0
votes
4answers
71 views

crontab not running as root

Mysql backup scripts not running as root crontab - help I'm trying to run a crontab as root but the script is not running successfully. I can see in syslog that the script is executing but it does ...
0
votes
0answers
13 views

CloudStack MySql issue

I am trying install cloudstack in lab. Have three host KVM, Management , MySql Server. Management - 10.X.X.10 MySQL-10.X.X.11 When i run this cloudstack-setup-databases cloud:xxxxx@10.X.X.11 ...
0
votes
0answers
47 views

Error “Cant connect To Mysql server through socket error”

I'm really having a hard time getting MySQL to work. I keep getting this error message when trying to connect via the mysql client: can't connect to MySQL server through socket ...
0
votes
2answers
52 views

how to connect to mysql server in another system from ubuntu

I am using ubuntu, and am programming in android. So in my application i need to connect to mysql database which is in another system. When i searched, i foud that wamp server is need, wanp only works ...
0
votes
0answers
14 views

MySQL Installation Error [duplicate]

I'm trying to install MySQL like this: sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql but I get this always: Reading package lists... Done Building dependency tree Reading ...
1
vote
1answer
45 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 ...