Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

4
votes
1answer
2k views

How do I copy MySQL databases to another Ubuntu machine?

I installed a LAMP server on my pc and created databases. Now I want to copy it to my friend's computer. How can I do this?
5
votes
2answers
4k views

PHP and MySQL not communicating

I have come to the conclusion that my PHP installation and my MySQL installation are not getting along; I’m working on making my first web page that uses MySQL for content, but after two days, man ...
0
votes
1answer
601 views

MySQL broken on localhost since update

all. After a recent 12.04 update (MySQL was updated), when trying to access my localhost site I get the following error: Database Error: Unable to connect to the Database: The MySQL adapter 'mysql' ...
-1
votes
2answers
805 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
432 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
874 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
5k 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
7k 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
8k 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
84 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
2k views

How do I setup php+My sql development environment

How do I setup php + My sql development environment in Ubuntu ?
0
votes
2answers
590 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
106 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
319 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
9k 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
635 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
329 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
492 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
4answers
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
591 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
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
337 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
503 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
196 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
174 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
131 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
26
votes
8answers
51k 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
448 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
441 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
176 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
236 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
1k 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
5k 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
15k 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
512 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
37 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 ...