Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

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
378 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
547 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
2answers
2k 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
3k 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
235 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 ...
5
votes
3answers
60k 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
716 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
842 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
805 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 ...
10
votes
3answers
13k 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
280 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
613 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?
4
votes
4answers
12k 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
600 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
297 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 ...
3
votes
1answer
11k views

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

I need your help. I wanted to install php , mysql and apache server How to run php web application in server? How to connect php web application to mysql?
0
votes
1answer
696 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
8k 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 = ...
2
votes
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
928 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
108 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
3k 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
174 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
310 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
165 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
208 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
710 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
287 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
201 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 ...
15
votes
3answers
44k 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
65k 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.
1
vote
1answer
730 views

Access denied for user 'tt-rss'@'localhost' after installing tt-rss

Just installed Tiny Tiny RSS. Accessing http://localhost/tt-rss from the browser brings me the following error: Unable to connect to database (as tt-rss to , database ttrss): Access denied for ...
1
vote
1answer
78 views

Ubuntu repository MySQL5.5 vs Orace MySQL5.5

Ubuntu repo mysqld executable file size = 12 MB. mysqld downloaded from Oracle website ~= 50 MB. I compiled mysqld and the size again came out to be ~= 50MB Mysqld 5.6 file size ~= 90MB How is it ...
2
votes
0answers
791 views

How I can connect the syslog-ng with a mysql database?

Hi guys I want to use a syslog-ng server for logging data from the firewall and I get Data from the Firewall in the file /var/firewall.log but now I want that the logs go to a database. For this I ...
1
vote
1answer
206 views

mysql datadir removed

I accidentally remove the document /var/lib/mysql and when I tried to connect to the databases, the following information came up: mysql> show databases; ERROR 1018 (HY000): Can't read dir of '.' ...
0
votes
1answer
515 views

How to check if openvpn is connected in Upstart?

I need to run a script after mysql and openvpn are started (Ubuntu for ARM). I can succesfully run the script with upstart with this .conf: # my upstart for logging boot start on (starting openvpn ...
15
votes
4answers
67k views

how to reinstall mysql?

A software upgrade broke, among other things, mysql and I have not been able to get it back up yet. Suspected cause: I had a near-full boot disk; the upgrade filled up the disk before completing and ...
1
vote
1answer
736 views

mysql client not found in ubuntu and I can't re-install it!

(On Ubuntu 12.04) The following terminal output is pretty much self-explanatory: [11:34:28] drossi@d ~/dbdumps$ mysql The program 'mysql' is currently not installed. You can install it by typing: ...
3
votes
2answers
4k views

How can I install specific version of MYSQL

I'm trying to install mysql-server 5.0. because I want to install a program which depend on this version. I've surfed the net to find a solution but none of them worked. I'm really disappointed. I ...
4
votes
4answers
55k views

Bash script not executing from crontab [duplicate]

I have the following bash script: #!/bin/bash mysqldump -u ******** -p******** --all-databases | gzip > /home/srvlinux01/MySQLBackups/database_$(date +\%Y-\%m-\%d).sql.gz which is located in ...
4
votes
2answers
10k views

set up mailserver for multiple domains guide for beginner

I am not Linux pro, and after days of trying with tutorials how to set up postfix or other e-mail server I am try to find solution here. In your office we have HP Proliant server with Ubuntu server ...
1
vote
2answers
3k views

Connect to MySQL on Ubuntu Server

The connection worked fine the other day and for some reason is doesn't. MySQL is running in Ubuntu Server 12.04 and I am trying to connect to a database using ODBC Connector 5.1 from Windows 7. I ...
0
votes
1answer
123 views

How to to use one instance of mysql database in a dual boot setup

I have a duel boot machine having Windows and Ubuntu 12.10. I was using MySQL database in my Windows machine and now want to use it form Ubuntu. I installed mysql in Ubuntu and set datadir. As ...
0
votes
0answers
22 views

Installation of MySQL Server 5.5 freezes on Ubuntu 12.04 LTS [duplicate]

I try to install MySql Server 5.5 on a virtual machine running Ubuntu 12.04. After executing sudo apt-get install mysql-server I get this screen: It seems that the installation is frozen. Any ...