Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
2k views

How to Automatically synchronize phpmyadmin on two lampservers?

My setup for my website is that i have a load balancer server, and two lamp servers and on the two lamp servers i have phpmyadmin installed. I have synced the two lamp servers /var/www folders with ...
1
vote
3answers
1k views

upgrade percona-server package fails

This has been happening for a few weeks. Every other package upgrades without issue except this one, but I'm not sure what's causing this or how to debug it. sudo apt-get upgrade Reading package ...
3
votes
0answers
529 views

Using gnome-keyring with svn via ssh and mysql-workbench

Problem: mysql-workbench fails to connect to the keyring to connect to mysql. I'm trying to get my svn command (which uses an svn+ssh uri) to prompt me to enter my password for my local rsa secrets. ...
4
votes
3answers
9k views

Recommended testing tools to test MySQL performance?

What is the recommended tool(s) for testing the performance of MySQL 5.5 (innodb) under Ubuntu 12.04? We have purchased a new multi-cpu multi-core server to replace our current MySQL dual-core ...
0
votes
1answer
394 views

Java Hibernate: Download MySql or LAMP

I am going to be writing a Spring based Java application and I was wondering if I should install MySql directly or should I just install LAMP. I would like to install LAMP, but would this have any ...
-1
votes
1answer
589 views

myloader Segmentation fault (core dumped) [closed]

myloader --directory=$DB_DUMP --queries-per-transaction=50000 \ --threads=$THREADS --compress-protocol --verbose=3 \ --socket=$MYSQL_SOCK --user=$MYSQL_USER --password=$MYSQL_PASS # ...
2
votes
6answers
14k views

Upstart can't start MySQL

After an installation of MySQL, I get a few errors and I can't run the MySQL daemon. I've tried uninstalling and reinstalling several times, and I'm not sure what's going on. Here's a snippit of what ...
1
vote
1answer
790 views

Mysql5.6 and problem of php5-mysql , mysql-common packages

I install Mysql 5.6 with this documentaion(in ubuntu 13.04) , now I need to install php5-mysql and mysql-common packages. can I install them with apt-get? I think they will install mysql5.5 ...
2
votes
1answer
2k views

Can't connect to mySQL server which is running

I installed the latest mySQL Ubuntu distribution on my Ubuntu 13.04. The installation of the localhost server was succesfull and was working fine for a while. After creating a couple models (with no ...
0
votes
2answers
1k views

How do I display an html file on a web browser in Ubuntu?

I am tasked with displaying a program on a web browser for my final project. The browser would be run from a cloud instance, and I have chosen to show an java applet that I have made. I have already ...
0
votes
1answer
2k views

Mysql Datadir on different hard drive

I'm currently running Ubuntu 13.04 and MySQL 5.5. I have been using InnoDB, and the default location for installation. The problem is that my main OS partition is fairly small (36GB), and I need to ...
0
votes
1answer
799 views

What won't MySQL start?

MySQL will not start, and I need some help to figure out why. $ download mysql-common [sudo] password for zero: Reading package lists... Done Building dependency tree Reading state ...
6
votes
1answer
18k views

Upgrade MySQL server issue [duplicate]

I failed to upgrade MySQL server. Here's what I tried: I first issue this command to update the package list: sudo apt-get update Then, upgrade by: sudo apt-get upgrade It shows the following ...
3
votes
3answers
4k views

Cannot get mysql to work/start even after clean install

I am completely stumped right now, whilst I am not an advanced user, I know my way around Ubuntu and so tried to look into things with the help of certain forum topics. The Problem: Today, quite ...
0
votes
1answer
316 views

g++ fails to link to libmysqlclient

I use Ubuntu 12.04 on a virtual machine on my MacbookPro. I installed build-essential, mysql-server and libmysqlclient-dev. Both commands 'mysql' and 'mysql_config' work. However, the following ...
1
vote
2answers
535 views

Partial upgrade - why remove MariaDB?

My 12.04 system wants to run a partial upgrade, as part of which it proposes to remove certain MariaDB packages (see screenshot below). Attached is my sources.list file - I don't understand why the ...
1
vote
3answers
1k views

no mysql workbench in ubuntu 12.04 software center

I have already installed MySQL workbench from the Software Center on a recent installation of Ubuntu 12.10 (32 bit) with no problems. Since then, I just installed ubuntu 12.04 LTS on another machine ...
1
vote
1answer
2k views

learning of mysql with java in ubuntu

Hello as Im new to ubuntu i want to learn Mysql database with Java,So how to install the software and configure them for the Programming in ubuntu 13.04
0
votes
1answer
228 views

Problem while moving Mysql DB from Windows to Ubuntu?

I was planning to move mysql DB from windows to Ubuntu. Whenever I try to change lower_case_table_names to 1 (for case insensitivity) using set query it says it is read-only variable. When I tried ...
3
votes
3answers
51k views

can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' [duplicate]

I just installed appache, MySQL and PHP, suring my installation, I was prompted for a MySQL root user password, but when I start my MySQL, it pops the error, and I just can't seem to find a way around ...
0
votes
1answer
690 views

mysql-client-core-5.5 : Breaks: mysql-client (< 5.5.31-0ubuntu0.12.04.1)

the automatic security update broke my mysql installation and I don't understand how to fix it. As far as I can tell the packages mysql-client-core-5.5 and mysql-client are on the same versio0n ...
0
votes
1answer
799 views

Can't install apache on Ubuntu 13.04 [duplicate]

I have apache files downloaded, and I've not been able to install the, it keeps listing dependencies and when I check my list of installed packages, it lists apache2 as deinstall, I equally have not ...
1
vote
2answers
650 views

Is there a way I can transfer all my web sites on localhost to a new computer?

I have a whole set of web sites on my Ubuntu computer that I use for testing and development. I don't host them on the internet, I just access them locally for design and debugging. Each one is built ...
5
votes
2answers
10k views

MySQL can't open files after updating server: errno: 24

Ubuntu: 12.04 LTS (Linux mysql02 3.2.0-40-generic #64-Ubuntu SMP Mon Mar 25 21:22:10 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux) MySQL: Ubuntu distro 5.5.31 Apparmor: REMOVED! Server has been running ...
0
votes
1answer
247 views

Ubuntu server boot without keyboard/monitor

Hope someone can help me with this unusual problem. I installed Ubuntu 12.04 server on a Gigabyte GA-H61M-USB3 motherboard. This all went well. I subsequently installed Apache, MySQL and PHP. This ...
1
vote
1answer
551 views

how to install apache/php from apt alongside mysql 5.6 from source

I managed to install MySQL 5.6 on obuntu 12.10 but now I need apache/php packages but when I try to install them thorough apt they try to install mysql-common (presumably 5.5) How to solve this?
3
votes
4answers
10k views

Can't install MariaDB 5.5 or 10 in Ubuntu 12.04. MYSQLD Failed to start?

I tried o install MariaDB on my Ubuntu 12.04 server. First it gave dependency issues and I fixed it by following this question : ...
0
votes
1answer
511 views

Bring in old databases in MySQL?

Ok, so when mysql updated a while back, it broke. It was simply not starting. So I tried fixing it, but hadn't been successful. I finally gave up, copied all the directories & files under ...
1
vote
2answers
266 views

Database create in mysql database

I am using Ubuntu 12.10 and recently I install XAMPP 1.8.1. My problem I can not create new database using both sql command and phpmyadmin. In phpmyadmin database creation input box is not shown and ...
2
votes
1answer
7k views

how to run php web application in lamp server and mysql connection also

i need your help. 1.i wanted to install php , mysql and server appache like.. 2.how to run php web application in server? 3.how to connect php web application into mysql.
0
votes
1answer
579 views

MyISAM problem after moving datadir of a MySQL database

I recently moved my MySQL database data directory from the default location /var/lib/mysql onto a new harddrive located in /media/..UID../mysql, following the steps you can find in several posts. ...
1
vote
1answer
6k views

why doesn't mysql create the pid?

mysql starts fine, everything is working as expected, but there is no pid file where my.cnf says it should be, the .sock is there this is the relevant section of my.cnf [mysqld] user = ...
1
vote
1answer
4k views

How to install the mysql connector for C#?

I installed Wine and now I have setup Mono & .NET When I try to compile the next sentence, I get an error because I don't have the MySQL connector installed on my system. using ...
0
votes
1answer
1k views

mysql-connector.jar vs mysql-connector.tar

I also have the "java.lang.ClassNotFoundException: com.mysql.jdbc.Driver" in Eclipse. I have found many tips and discussions about jdbc in Eclipse, however none of them work so far. I keep reading ...
0
votes
1answer
1k views

Bitnami says 'no enough permissions to bind to the port…'

I am installing wordpress of Bitnami in ubuntu 12.04 amd64. When I run installation, it pops a window letting me choose 'MySQL Server port'. I use the default 3306. But it says : It seems you do not ...
0
votes
1answer
839 views

What's wrong with PHP 5.4.6 and what can I do about it?

I recently installed Ubuntu 12.10 server with the stock version of Apache2, PHP and MySQL. Something is wrong with PHP - first I thought it was an issue with PHP Markdown, as the script came to a ...
0
votes
1answer
1k views

Mysql very slow on (fast) development laptop

[Solved] Ubuntu 12.10 x64 new i7 laptop, mysql default installation. Importing a 6 MB dump file (a empty drupal dump made mostly of INSERT INTO statements) takes ~30 minutes, on other PC takes less ...
1
vote
2answers
103 views

Installing MySQL in LAMP

I managed to install Apache and PHP on my Ubuntu Installation, however when I try to install MySQL using this command sudo apt-get install mysql-server It mentions that there are broken packages. ...
2
votes
2answers
2k views

How I can set-up MySQL on Lubuntu for education purpose?

I have Lubuntu 12.10 x86 on my notebook with all updates. I downloaded and install MySQL Community Server and MySQL Workbench. I learning Java and our next lesson will be about MySQL. I need to ...
0
votes
1answer
152 views

while installing phpmyadmin i am getting an error

while installing phpmyadmin i am getting following error E: Sub-process gzip returned an error code (100) E: Prior errors apply to /var/cache/apt/archives/php5-gd_5.4.6-1ubuntu1.2_amd64.deb ...
0
votes
1answer
296 views

.profile file not getting updated in Ubuntu 12.04, trouble installing mysql

I'm trying to install mysql in ubuntu to run ruby on rails. I was going through the tutorial at Lynda. I have successfully installed ruby, gem & rails. ruby -v ruby 1.8.7 (2011-06-30 patchlevel ...
1
vote
1answer
156 views

Create database

I want to create database. I know that I should use the following code: mysqladmin -h localhost -u {username} -p create lrs I don't know if something should be replaced with username located between ...
1
vote
0answers
189 views

Can not install phpmyadmin and mysql

after an interrupted upgrade of ubuntu 10.04 server LTS to ubuntu 12.04 server LTS somethings weren't installed correctly. Anyways I installed apache, ftp, phpmyadmin etc. At some point I deleted some ...
1
vote
1answer
559 views

mysql error: Can't create a new thread (errno 11)

I have a db server running MySQL Server, and 5 slaves. I always get the error: mysql error: Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual ...
2
votes
1answer
249 views

upgrade MySQL through apt not effect?

I am upgrading mysql-server and mysql-client my 12.04 using apt-get. seems the upgrade didn't take effect? Any thoughts why this happen? I did reboot after upgrade. Thanks. $ mysql -V mysql Ver ...
0
votes
1answer
191 views

How to I resolve this error after trying to install mysql on Ubuntu Desktop 12.04?

I am getting the following error when trying to install mysql-server on Ubuntu 12.04 sudo apt-get install mysql-server Reading package lists... Done Building dependency tree Reading state ...
2
votes
4answers
1k views

Why I can't open mysql 5.6.10 from terminal on Ubuntu 12.10?

I've always used Ubuntu to host my servers and I wanted to try the new MySQL version. So I downloaded MySQL 5.6.10 (.deb) from their official site and installed it like this: Tutorial for MySQL ...
13
votes
3answers
35k views

Port 3306 appears to be closed on my Ubuntu server

I have two VPS servers, and both have MySQL installed, one for testing and one for development. One of my servers won't let me connect from outside. With the user; 'mytestuser'@'%' According ...
7
votes
5answers
57k views

How to connect and create a database in MySQL?

I want to install MySQL and create a database on it using the following code: sudo apt-get install mysql-server mysqladmin -h localhost -u {username} -p create lrs I get the following message after ...
0
votes
2answers
2k views

How to configure JDBC, Tomcat for Eclipse IDE on my Ubuntu 12.04

I got an eclipse IDE on my client's machine. He needs to configure JDBC, and Tomcat on this IDE to use for his Java projects. Kindly help. He got mysql installed right now.