Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
2answers
6k views

phpMyAdmin - Display all queries

I have installed a fresh desktop with ubuntu quantal and the following packages versions: MySQL: 5.5.28-0ubuntu0.12.10.1 Apache: 2.2.22 (Ubuntu) phpMyAdmin: 3.4.11.1deb1 I would like ...
1
vote
1answer
354 views

Installing apache , php and mysql on ubuntu 8

I want to install php, mysql and apache on my ubuntu , I tried all tasks but I can not do it. there is no package php, apache or mysql please help me
0
votes
1answer
2k views

MySql #2002 problem [duplicate]

Possible Duplicate: My MySQL installation is broken. How to completely reconfigure it? When i try to login in apache i get a #2002 error. When i try to login in MySQL via terminal it ask my ...
0
votes
1answer
2k views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

My mysql installation was screwed up. I uninstalled and installed it multiple times. But I kept getting a hang or a error "cant connect". I now finally have it running with sudo -u mysql mysqld. How ...
0
votes
1answer
522 views

mysql does not start or work

Recently I installed LAMP with tasksel. Then I remember I issued some commands to get into the mysql console - it worked. Right now I checked - apache and php modules work perfectly. But as for mysql ...
1
vote
0answers
215 views

Unable to insert the form values into database [closed]

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> ...
0
votes
1answer
2k views

Mysqld won't start after reboot

nothing in /var/log/mysql*. syslog shows: Oct 25 09:55:28 mx mysqld: InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 14:55:28 ...
1
vote
1answer
1k views

Apache / MySql is not running. What is wrong?

I installed lampp / xampp on my Ubuntu 12.04. After installing, Apache and MySQL were running properly. Now, they're not. Here's what I get when I try to run apache: Command: /etc/init.d/apache2 ...
0
votes
1answer
187 views

MySQL install error?

I'm trying to get a lamp server running on my ubuntu installation. I have SSH and Apache working without any problems. I installed MySQL with sudo apt-get install mysql-server mysql-client As usual ...
0
votes
1answer
143 views

Which package of MySQL should I choose from the software center?

When installation MySQL in ubuntu software center There are two programs Mysql server Mysql client Whichever is chosen for the installation MySQL
29
votes
8answers
55k views

How to install MySQL 5.6?

I just installed Ubuntu 12.10 (amd64), and want to install a recent version of MySQL 5.6. If possible, I would like to install (not upgrade) it the "Debian Way' (i.e., using apt-get or dpkg).
1
vote
1answer
3k views

PhpMyAdmin shows warning: PHP MySQL library version 5.0.51a differs from your MySQL server version 5.5.24

Installed Mysql on Ubuntu 12.04 Server via apt-get install mysql-server from default sources.list. Than uploaded new Phpmyadmin version shows warning: Your PHP MySQL library version 5.0.51a ...
2
votes
1answer
490 views

LAMP Stack Location

I have installed the LAMP stack on Ubuntu 12.04 LTS using the tasksel command. I checked - it works. But I cant find the location of the installaton, I worked with WAMP - there you have a separate ...
1
vote
1answer
463 views

Can I scale out the mysql charm instead of adding another database?

I have question how to scaling mysql service because I make deployment from here: https://juju.ubuntu.com/docs/user-tutorial.html And I have wordpress and mysql related but is there possible to scale ...
1
vote
0answers
180 views

public address null and present state pending after destroy-environment , disabling firewall and bootstrap again [closed]

I have done everystep as it was written on ubuntu 12.04 maas, but now i am stuck here for over a month and could not find how to solve it .. Please help .. When i do juju status it says : ...
2
votes
1answer
253 views

Is it safe to Install Both Redis and MySQL on the same system?

Mine is a question not on how to install either but on whether I can have both MySQL and Redis-Server on my Ubuntu 12.04 machine. I need both for different projects, any help forthcoming will be ...
1
vote
2answers
2k views

Cannot reinstall MySql in 11.10 - ERROR: There's not enough space in /var/lib/mysql/ [closed]

I've tried it all (removing all the packages associated with MySQL) but keep getting stuff like this: Preconfiguring packages ... (Reading database ... 142196 files and directories currently ...
2
votes
2answers
6k views

phpmyadmin 404 error on fresh ubuntu 12.04 install

I regularly set up Virtualbox ubuntu setups to run as local webservers. I have set these up several times and never had an issue. However, something has changed: 1)VB guest additions no longer allow ...
5
votes
4answers
17k views

Restoring MULTIPLE MySQL databases from one file at the command line?

I have exported all my databases to a file using phpMyAdmin. Unfortunately I don't have a working phpMyAdmin in my destination system. How should I restore all of them at once using one line ...
0
votes
2answers
541 views

Problem in redirecting standard input and output

I want to take backup of my mysql data using mysqldump. I have three files containing names of mysql tables line by line. My script has this line - mysqldump -h localhost -uroot --lock-tables=false ...
1
vote
0answers
38 views

Ubuntu 12.04.1 LTS mysql failed to start [duplicate]

Possible Duplicate: Can't start mysql - mysql respawning too fast, stopped I have Ubuntu 12.04 LTS server which was running OK along with MySQL service ,i had to reboot the server ...
11
votes
5answers
11k views

Enabling SSL in MySQL

I'm running Ubuntu Server 12.04, and I want to enable SSL connections to MySQL. I've generated the following keys/certs files with OpenSSL: ca-cert.pem server-cert.pem server-key.pem I stored ...
0
votes
1answer
294 views

What are the executable names of MySQL client and Admin Application (GUI)?

I've tried searching for for my MySQL client and manager using Dash Home, and cannot find them. I've tried using find on the command line, but don't know what the application names are respectively. ...
1
vote
3answers
4k views

Postfix + Dovecot - not receiving mail in vmail directory

i have been spending countless hours on this and now i figured id come to the 'internet' for help. I have installed a new install of postfix + dovecot + mysql. Right now, i am able to receive email ...
1
vote
1answer
801 views

Install Joomla on NGINX in Ubuntu 12.04

I'm installing Joomla on NGINX and so far everything is going fine until I get to the page where is checks Pre-Installation parameters. It says Database Support : No I've already checked ...
1
vote
1answer
5k views

MySQL 5.5 - Lost connection to MySQL server during query

I have an Ubuntu 12.04 LTS server running at a german hoster (virtualized system). # uname -a Linux ... 3.2.0-27-generic #43-Ubuntu SMP Fri Jul 6 14:25:57 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux ...
3
votes
4answers
20k views

How to upgrade mysql 5.5 to Mysql 5.6 on 12.04? [duplicate]

I need to install Mysql-server-5.6 in my ubuntu development server 12.04. Now it is running percona-server5.5. How can i upgrade this to mysql-5.6 ?
2
votes
1answer
95 views

How do I turn on a login page for Bugzilla?

I have Bugzilla 4.2.1 running on my Ubuntu 11.10, It working as it should and everything is fine. Now when somebody accesses the URL www.myapplication.com/bugs without logging in, it allows the user ...
0
votes
1answer
398 views

Ubuntu 12.04 MySQL 5.5 MyODBC 5.1 or 3.1 query hangs

I have been able to install Ubuntu 12.04 with LAMP MySQL version 5.5.x It works fine within linux, it allows me to connect from myodbc windows vista or windows 7 I have configured networking access ...
0
votes
2answers
29k views

Getting access to var/www [duplicate]

Very, very new user to Ubuntu and I've been searching for a long time without finding an answer. Probably I've gotten the answer but I don't understand it all that very well so I thought I try this ...
4
votes
1answer
507 views

Any good SQL shell programs?

I want to practice SQL commands on Ubuntu. I would just like to play with different commands and keywords. Where can I find something that helps? I don't want to install any server. I need a small ...
0
votes
1answer
638 views

cannot locate phpmyadmin [duplicate]

I successfully installed phpmyadmin, via apt-get install phpmyadmin However I can't find the directory for phpmyadmin, I want it to appear on /var/www/phpmyadmin so that I can use it via URL. Where ...
0
votes
2answers
5k views

Setting ServerTokens and ServerSignature in Apache

I have been following this tutorial closely http://net.tutsplus.com/tutorials/php/how-to-setup-a-dedicated-web-server-for-free/comment-page-8/#comments I have installed Apache php & MySql I ...
0
votes
1answer
3k views

How can I access Ubuntu Server using MySQL Workbench and FileZilla?

How can I access Ubuntu Server using MySQL Workbench and FileZilla so that I can work on database and files from local Windows PC?
0
votes
1answer
640 views

After installing mysqli phpmyadmin stop loading

On Linux host 3.2.0-30-generic #48-Ubuntu SMP Fri Aug 24 16:52:48 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux phpmyadmin won't load after installing mysqlnd. I'm using php5, mysql AND mysqlnd. Maybe ...
5
votes
2answers
21k views

How can I install MySQL along with phpMyAdmin?

I installed php5 from the Software-Center and it came along with Apache2. How can I install MySQL database along with phpMyAdmin?
1
vote
1answer
5k views

Error installing MySQL Ubuntu 12.04, dependency? [duplicate]

Possible Duplicate: MySQL server stopped working after upgrade I'm trying to install MySQL 5.5 on Ubuntu 12.04, but I'm stuck with this error: Setting up mysql-server-5.5 ...
3
votes
1answer
862 views

Unable to install mysql under Ubuntu 12.04 LTS [duplicate]

Possible Duplicate: How to get MySQL back on Ubuntu 12.04? i'm getting the following error when trying to install MySQL Server under Ubuntu: Setting up mysql-server-5.5 (5.5.22-0ubuntu1) ...
1
vote
1answer
137 views

ubuntu screen black after log in

I have a problem with my ubuntu install. After I get the log in prompt, the screen goes black and never comes back. But I know the system is running because I can ssh into the box and my websites ...
2
votes
1answer
526 views

Where is mysqld.sock?

I am missing mysqld.sock in Ubuntu Server 12.04. Neither locate nor even apt-file search mysqld.sock (ran apt-file update before) can find it. Where is it?
0
votes
0answers
24 views

How to instal LAMP for Ubuntu 12.04 LTS? [duplicate]

Possible Duplicate: What's the easiest way to set up a LAMP stack? I'm studying SQL database right now and I need a mySQL server. I was guided to use a LAMP server on Linux .. but I ...
2
votes
2answers
5k views

Cant see databases of mysql from command prompt in ubuntu 12.04

1) I have installed mysql server and mysql client through apt-get install mysql-server and apt-get install mysql-client 2) when I run sudo netstat -tap | grep mysql, I see following: tcp 0 ...
1
vote
1answer
1k views

How do I get mrbs installed and working?

I'm trying to install Meeting Room Booking System on ubuntu 12.04 I think I have apache and php5 up and working fine. A test.php file with contents: <?php phpinfo(); ?> loads and gives me ...
0
votes
2answers
3k views

Ubuntu 12.04 Mysql doesn't start on reboot; starts ok later manually

I've just installed MySql to support a mediawiki install on 12.04 64bit. Everything appears to be working ok, except that at boot-up, mysql server fails to start. This results in an error appearing on ...
7
votes
2answers
9k views

mysql doesn't update due to error in apparmor profile

I got a mysql error after the update of it. This is the log. (Leyendo la base de datos ... 559752 ficheros o directorios instalados actualmente.) Desinstalando mysql-server ... Configurando ...
4
votes
3answers
7k views

Unable to start mysql server after update

Today I updated the system, and I cant start the mysql server: I'm getting the following error: Aug 14 14:32:09 VULTURUS kernel: [ 1996.413190] init: mysql main process (14122) terminated with ...
1
vote
2answers
5k views

How do I find my firewall is blocking mysql?

I'm very new to Ubuntu. I couldn't able to connect to mysql via my programming language. I know all my property file in my code is correct. But still I couldn't able to connect to mysql. I guess my ...
4
votes
1answer
5k views

Connection failed to open the DB connection: could not find driver

I am newbie for ubuntu and I was trying to run lamp. I installed mysql, and pdo extensions. when i show config(with phpinfo()): Configuration File (php.ini) Path: /etc/php5/apache2 Also I see mysql ...
0
votes
1answer
4k views

why is apt-get not install mysql server 5.5

I have mysql server 5.1 installed. I want to update it to 5.5 . I took a back up and uninstalled 5.1 using this command sudo apt-get --purge remove mysql-server* when I again used apt to install ...
2
votes
1answer
2k views

MySQL keeps failing to install

First I clean up previous installation root@ip-10-134-10-182:~# rm -rf /var/lib/mysql root@ip-10-134-10-182:~# rm -f /var/lib/dpkg/lock root@ip-10-134-10-182:~# rm -f /var/cache/apt/archives/lock ...