Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
27 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
8 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
21 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
32 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
40 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
19 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
22 views

Apache unable to connect to MySQL

I installed apache server (this story). I cannot connect with mysql server. After a long loading page I get error MySQL database connect failure. Mysql server is far from me. On same page which locate ...
1
vote
2answers
37 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
16 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
32 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
0answers
14 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
36 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
17 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
21 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
22 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
19 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
33 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
32 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
45 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
40 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
95 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
24 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
46 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
9 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
67 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
12 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
42 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
47 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
41 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 ...
2
votes
4answers
74 views

Unable to send data to mysql database. It is not taking by my php code

I am new to PHP in Ubuntu 13.10. But I am pretty much able to handle Ubuntu. However my question is that I can't add any data to phpmyadmin through a PHP code, though my code is perfect. Because I ...
2
votes
1answer
149 views

Remotely access mysql db on vm from windows as host [closed]

I have ubuntu on vmware. I've installed mysql-server on it. And now I'd like to connect to this db directly from the Host(windows) machine. Ubuntu is connected to the router via bridge. I can ping it ...
1
vote
0answers
22 views

mysql usage and upgrade [closed]

i am using the 11.04 version of kubuntu . is the mysql is already installed in it as i am not able to install the new version of the mysql. and getting the errors Reading package lists... Done ...
1
vote
1answer
34 views

Mysql data provider for TORA

I was a MySQL query browser user in Windows. I switched to Ubuntu 13.10 and now I can't get MySQL query browser so I tried TORA referenced from MySQL GUI Tools Now I could not get any option in ...
0
votes
0answers
27 views

Error when installing mysql on ubuntu [duplicate]

I get This error when I try to install MySQL on ubuntu: sudo apt-get install mysql-server [sudo] password for xxxxx: Reading package lists... Done Building dependency tree Reading state ...
0
votes
0answers
158 views

Mysql cannot start when upgrade 5.5 to 5.6

I following this link to upgrade my mysql, https://rtcamp.com/tutorials/mysql/mysql-5-6-ubuntu-12-04/ The article ubuntu is x64, But my ubuntu is x32, So I change the download link to ...
1
vote
2answers
124 views

Unable to install mysql 5.6 in ubuntu 12.04

I download mysql-5.6.16-debian6.0-x86_64.deb from official site. Install using dpkg -i mysql-5.6.16-debian6.0-x86_64.deb It does create file in /opt/mysql/server-5.6/. root@ubuntu:~# cd ...
0
votes
0answers
28 views

How to solve mysql dependency problem [duplicate]

Hi I ran the following command sudo apt-get upgrade However I'm getting the following You might want to run 'apt-get -f install' to correct these. The following packages have unmet ...
2
votes
0answers
17 views

SSL is not in use on MySQL server [duplicate]

I installed MySQL server and I want to allow SSL support. I added these lines to my.cnf [client] ssl-ca=/etc/mysql/ca-cert.pem ssl-cert=/etc/mysql/client-cert.pem ssl-key=/etc/mysql/client-key.pem ...
0
votes
0answers
106 views

Xampp control panel does not starts because of pre installed mysql and apache server

Recently I installed xampp for my ubuntu 13.10, 32-bit. Before sometime I had installed mysql and apache server individually to test few things. My Problem : When I try to start mysql and ...
1
vote
0answers
65 views

What does this mysql error mean?

I'm on Xubuntu 13.10 64 bit. I know the password of my mysql database, but still can't login as root. I try to change the password sudo mysqld_safe --skip-grant-tables & I get [1] 8863 mypc ~: ...
0
votes
1answer
79 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
89 views

How do I set up a Tor server?

I would like to host a tor hidden services website (aka .onion site) on my Ubuntu desktop with the LAMP stack installed. While the tor docs offer some guidance on running an anonymous server, the ...
0
votes
0answers
38 views

Install MySQL Drivers?

The instructions here tells me to install: libtdsodbc.so but how do I install a .so file in Ubuntu 13.10? I'm trying to connect to a MS SQL DB to extract data into MySQL DB. I have MySQL ...