Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

-1
votes
2answers
884 views

Why does my MySQL remote-connection fail (VLAN)?

ubuntu-community! Again I have a problem with my special friend MySQL :D I have got two servers - a database-server and a web-server - who are connected via VLAN. Now I want the web-server to have ...
0
votes
1answer
4k views

Problem after mysql-server installation I cant install any thing in ubuntu 12.04.1 now

I'm not an advanced user of Linux and I tried to install work with database so I installed Mysql-server, I think I did same thing wrong so I get in trouble and now I cant install any thing and this ...
0
votes
2answers
451 views

MySQL does not start up on ubuntu 12

MySQL Server does not start up on ubuntu 12. When I run the status command, the following message is displayed: ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
3
votes
0answers
1k views

Why can't I reinstall MySQL? [closed]

List item I've been looking all around the Internet for an answer but didn't find anything. I hope you can help me now. I have a server with MySQL. From one day to another, MySQL didn't let me ...
0
votes
1answer
958 views

MySQL port forwarding

I am trying to help a colleague to connect to my MySQL server. However the situation is a bit special, and here's why (let's call him person A and me, person B): Person A has a PC, on which he has a ...
1
vote
1answer
2k views

mysql show databases not showing databases that are in /opt/bitnami/mysql/data directory

and thank you for taking the time to look at my question. I have an ebs-backed ec2 ubuntu server which is running but unreachable. ** There are very stupidly no recent backups ** I made a snapshot ...
3
votes
1answer
6k views

mysql not starting

I have a server running on rackspace.com, it been running for about a year (collecting data for a project) and no problems. Now it seems mysql froze (could not connect either through ssh command line, ...
3
votes
2answers
8k views

Error 1130 connecting to MySQL on Ubuntu Server 12.04

I hope this is the right place for this...I currently am running Ubuntu Server 12.04 through VirtualBox on a Windows 7 host. I am trying to connect to the VM's MySQL engine using MyDB Studio for ...
0
votes
5answers
9k views

how to stop mysql server with root

How can i stop mysql server (installed using binary installation under /usr/local/mysql)? When i go in /usr/local/mysql/bin and execute command mysqld stop i get following error message : [ERROR] ...
1
vote
1answer
88 views

When does MySQL server start when my system starts up?

I installed MySQL using apt-get ..., and when I press the power button, while my system boot up, MySQL starts automatically. But I want to know what's the time it starts exactly, and through which ...
0
votes
1answer
2k views

Offline MySQL installation (Using deb file and no internet connection)

I downloaded MySQL's installation package and ran the following command after installing a fresh Ubuntu server. dpkg -i mysql-5.5.28-debian6.0-x86_64.deb It installed fine and then I tried starting ...
1
vote
3answers
3k views

How do I setup php+My sql development environment

How do I setup php + My sql development environment in Ubuntu ?
0
votes
2answers
626 views

installing apache2, php5, mysql, phpmyadmin

I used the following commands sudo atp-get install apache2 sudo apt-get install mysql-server sudo apt-get install php5 sudo apt-get install phpmyadmin sudo /etc/init.d/apache2 restart after ...
0
votes
1answer
1k views

ERROR 1018 (HY000): Can't read dir of './depot/' (errno: 13)

I want to use of symbolic link for change path database in mysql. I create a Directory ,then create a symbolic link to this directory but when I want to use of this database get following error: ...
1
vote
1answer
110 views

Recent Ubuntu update prevents MySQL root access

I recently updated my Ubuntu (10.04 LTS) server (apt-get update, apt-get upgrade), and everything works fine, apart from the root access to my MySQL database. phpMyAdmin, CakePHP, and essentially all ...
2
votes
0answers
353 views

Another apparmor / mysql wont install

I am trying to config another instance of mysql on my present but i can't mysql_install_db --user=mysql --datadir=/var/lib/mysql2 Installing MySQL system tables... ERROR: 1005 Can't create table ...
0
votes
1answer
1k views

I can't start mysql in ubuntu 11.04

I downloaded following files of Oracle.com: MySQL-server-5.5.28-1.linux2.6.i386.rpm<br/> MySQL-client-5.5.28-1.linux2.6.i386.rpm<br/> MySQL-shared-5.5.28-1.linux2.6.i386.rpm<br/> ...
4
votes
3answers
11k views

Dependency problem with mysql-server-core-5.5 [closed]

When I start the Ubuntu software centre, it says I cannot do anything until the package catalog is repaired. However, repairing fails. I ran sudo apt-get -f install and found the problem to be: ...
1
vote
1answer
5k views

mysql completely removing

I broke my mysql and now I want to completely reinstall it. I tried: $ sudo apt-get install --reinstall mysql-server $ sudo apt-get remove --purge mysql-client mysql-server But always I see popup ...
0
votes
2answers
760 views

How to make a Portable Server for ubuntu?

I want my server to be portable so it will be available everywhere when I plug it in to other ubuntu computers. Like I want to use it at school, I will just have to run a script and the server runs. ...
0
votes
2answers
3k views

Errors installing php5-mysql extension

Getting error when installing php5-mysql. Looks like a dpkg error. Perhaps a broken package. Have tried to fix the broken package. Have reinstalled the lamp server and everything seems fine except ...
7
votes
1answer
400 views

How disable mysql command in sudoers file?

How can I disable /usr/bin/mysql command in sudoers file? I've tried to use it this way: %tailonly ALL=!/usr/bin/mysql But when I access user 'tailonly' of group 'tailonly', this command is still ...
-2
votes
1answer
596 views

dependency problems at installation from mysql-server-5.5 [closed]

qcons@014-QCONS:/var/lib$ sudo apt-get install -f mysql-server Paketlisten werden gelesen... Fertig Abhängigkeitsbaum wird aufgebaut Statusinformationen werden eingelesen... Fertig ...
0
votes
5answers
3k views

Another MySQL daemon is already running?

root@jose-desktop:~# sudo /opt/lampp/lampp start Starting XAMPP for Linux 1.7.7... XAMPP: Starting Apache... XAMPP: Another MySQL daemon is already running. XAMPP: Starting ProFTPD... XAMPP for Linux ...
2
votes
1answer
617 views

MySQL Replication

I have 2 MySQL servers, Master & Slave , running on Ubuntu 12.04. I have replication working from the Master to the Slave. If the Master goes down and the Slave is used, how do I get data to ...
1
vote
0answers
2k views

Unable to install mysql in ubuntu [closed]

I purged my existing mysql-server from ubuntu and re-installed the same. This was due there was an upgrade from my ubuntu and I was unable to start my sql-server. After cleaned up and taking backup ...
1
vote
2answers
7k 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
356 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
526 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
222 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
190 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
146 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
57k 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
503 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
473 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
181 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
265 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 ...
6
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
552 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
12k 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
300 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 ...