Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
267 views

Ubuntu 10.04 server delay when POST to mySQL

I have a Ubuntu 10.04 Server and for some reason it always seems to exhibit an intermittent delay whenever performing CRUD operations on the mySQL database. Most Post commands are executed within a ...
0
votes
2answers
653 views

Is it important to leave mysql running in the background ? Is there a gui to control processes on Ubuntu 12.04?

Im using BootUp Manager (bum) to control auto-start processes on Ubuntu 12.04. I have stopped Apache2 from starting automatically using bum. The problem is, today I have found that sql server is ...
0
votes
1answer
65 views

upgrade to 12.04, mysqld up but can't log on

Sorry if this is the wrong place to post. I upgraded to 12.04 and mysql stopped working. I re-installed mysql server package. When I try to log on to database I get: ERROR 2002 (HY000): Can't ...
5
votes
1answer
9k views

Why it can't connect to local mysql server due ERROR 2002?

I installed the mysql-server from the repositories, and wanted to change the datadir to a custom location. With the datadir set to /var/lib/mysql I was able to start the server, but to the new ...
1
vote
1answer
65 views

Failing installation of Mysql

start: Job failed to start invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.5 (--configure): subprocess installed post-installation script returned error ...
0
votes
1answer
7k views

mysql: unrecognized service (apparmor)

Many questions on this point but I couldn't any help yet. Mysql was working then I tried to move mysql database directory as (in this question)[http://askubuntu.com/questions/224/how-to-i-move-mysql-...
5
votes
3answers
6k views

Debconf errors when configuring mysql-server

When I try to run sudo apt-get upgrade I get the error below. I also get similar error when running sudo reconfigure postfix, which I relly need to run since outgoing e-mail is not working any more. ...
-1
votes
1answer
20k views

How can I use Mysql command line client in Ubuntu 12.04?

I just upgraded Ubuntu 11.10 to 12.04 (installed within windows 7) and during installation the process asked me to set my Mysql root password. According to Ubuntu Documentation, Mysql server is pre-...
0
votes
1answer
335 views

Problem sharing Mysql data on dual boot machine

First of all let me say that this is a question following my attempt to do the solution on this post Can I share MySql database files with Windows on dual boot? . I was hit by an error and need help ...
12
votes
4answers
6k views

OpenSource Document Management

I'm looking for Web-based, Opensource, PHP-MySQL Document Managment for my organization with these features: Features : Full text searching Document Metadata User access previledges Document ...
1
vote
1answer
18k views

How to deal with MySql ERROR 1133 (42000): Can't find any matching row in the user table?

I am constantly get the following error message: 1045 Cannot log in to the MySQL server I have tried the following: sudo service mysql stop (Went fine) sudo /usr/sbin/mysqld --skip-grant-...
0
votes
1answer
516 views

why phpmyadmin didn't work?

When run phpmyadmin it is not working and i get this message: Not Found The requested URL /phpmyadmin/ was not found on this server. Apache/2.2.22 (Ubuntu) Server at localhost Port 80 How it's not ...
1
vote
1answer
716 views

Installed mysql but cannot login: Access denied for user 'xxxxxx'@'localhost' (using password: YES)

Installed MySQL - but not able to login with the user I created. It gives me the following error. Access denied for user 'xxxxxx'@'localhost' (using password: YES) Please help.
0
votes
1answer
378 views

How to access Ubuntu server 12.10 via hostname,

I had it working, but then installed LAMP and a few other things to set up a webserver, now PUTTY only allows connection via IP, which works, and Webmin worked with hostname as well, until now... I ...
7
votes
1answer
20k views

Can't start MySQL server if the .sock file is changed in /etc/mysql/my.cnf

I have installed MySQL server 5.5 on Ubuntu 12.04. I am trying to start MySQL server on a different sock file. By default MySQL runs on /var/run/mysqld/mysqld.sock. I am trying to run the same server ...
8
votes
1answer
8k views

Is it safe to delete preinstalled MySQL databases like INFORMATION_SCHEMA?

I just installed the LAMP server and PHPMyAdmin. Once I logged in I noticed databases already created and within them tons of tables and rows. My question of course is whether I can just delete them ...
4
votes
1answer
4k 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?
8
votes
2answers
10k 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
808 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
1k 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
482 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 '/var/run/...
3
votes
0answers
2k 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
1k 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 ...
2
votes
1answer
3k views

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

I have an ebs-backed ec2 ubuntu server which is running but unreachable. There are very stupidly no recent backups. I made a snapshot of the block, created a volume, spun up a new instance, ...
3
votes
2answers
10k 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, ...
4
votes
2answers
10k 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 MySQL,...
0
votes
5answers
12k 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
95 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 ...
1
vote
1answer
3k 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
5answers
4k views

How do I setup php+My sql development environment

How do I setup php + My sql development environment in Ubuntu ?
0
votes
2answers
819 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
2k 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
116 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 ...
3
votes
0answers
434 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/> ...
5
votes
3answers
15k 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
7k 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
1k 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
5k 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
524 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 ...
0
votes
5answers
4k 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
675 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
2answers
9k 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
412 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
566 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 ...
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 ...