Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

4
votes
4answers
14k 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
673 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
320 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 ...
4
votes
1answer
14k 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?
1
vote
1answer
744 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. ...
2
votes
1answer
9k 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
5k 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
2k 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
979 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
110 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
185 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
315 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
172 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
223 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
810 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
303 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
203 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
4answers
51k 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
70k 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
3k 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
774 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
79 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
827 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
266 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
569 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 ...
17
votes
4answers
77k 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
765 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: ...
4
votes
2answers
7k 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 ...
5
votes
4answers
63k 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
11k 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
125 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 ...
3
votes
4answers
34k views

The phpMyAdmin configuration storage is not completely configured

I typed apt-get install phpmyadmin and ran into an error saying it cannot connect to mysql (socket issue). It was normal because I forget to install mysql before, so I selected "abort" above all ...
10
votes
6answers
31k views

dpkg: invoke-rc.d: initscript mysql, action “start” failed

I have read a number of the posts here and they all state to run the following commands: Apt-get -f remove ** apt-get update apt-get upgrade apt-get -f install ** I have seen these in various ...
0
votes
1answer
280 views

Can someone make this modx .htaccess file work for me? I am trying to make friendly URLs work

I now have my ModX install working but am unsure how to edit my htaccess file so my friendly urls (trying to alias pages) can anyone help? If you can a copy of my htaccess can be found at ...
1
vote
3answers
5k views

Nohup with mysql command

I need to run in background mode some mysql-query... But how can i do this with nohup? Standartly i do: musql -uroot -p use SomeDb; Select * from blablalba; But how can i do this with launching ...
1
vote
2answers
4k views

Error configuring PHP and MySQL installed from source

I'm using ubuntu 12.04. the system requires php5.2 and mysql5.1. I installed php and mysql from source. I encountered the following problem while configuring php: ./configure \ ...
2
votes
3answers
11k views

How do I import an mdf database file into MySQL?

I have an .mdf file(which is supposed to have database). I'm using Ubuntu 12.10 . I want to import the database into mysql.5.5.28-0ubuntu0.12.10.2 (Ubuntu) as this is version I'm using for mysql.
1
vote
4answers
8k views

MySQL Workbench installation issue on Ubuntu 12.04 , 64-bit system

I am getting dependency package errors as: root@osscube:/home/abdul/Downloads# dpkg -i mysql-workbench-gpl-5.2.47-1ubu1004-amd64.deb Selecting previously unselected package mysql-workbench-gpl. ...
5
votes
2answers
2k views

Is there a Linux equivalent to LinqPad?

I've recently been finding myself writing more SQL, on Windows with MSSQL and LinqPad and while I want to experiment on Ubuntu to get more of a handle on databases and I have no love lost for MSSQL, ...
3
votes
3answers
4k views

Why can't I install php-mysql?

In Windows I use Xampp. I have tried to install MySQL from the command-line and I can access MySQL through workbench software. Now if I try to run Wordpress on my computer, I get an error that "Your ...
13
votes
7answers
44k views

Unable to set password for the mysql “root” user

I am new to Ubuntu. I am running Ubuntu 12.10. I am trying to install apache,php,mysql. However I have installed apache and it is running perfectly. sudo apt-get install apache2 But when I tried to ...
1
vote
2answers
773 views

Mysql Server shuts down periodically on ubuntu

Mysql Server shuts down periodically on Ubuntu. I looked through the system log file and found the following lines in the log files i checked : Out of memory: Kill process 719 (mysqld) score 114 or ...
3
votes
1answer
862 views

root cron job not running

I am trying to configure automysqlbackup to run via a cronjob to backup my dbs nightly. When I execute sudo automysqlbackup from a terminal, the process executes as expected and creates the backup ...
2
votes
1answer
1k views

How to fix AppArmor `could not open` error when installing php+mysql?

I want to install php5-imap php5-ldap php5-curl sudo apt-get install php5-imap php5-ldap php5-curl I get this error: AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in ...