Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
1k views

Forward Mysql logs to Syslog-ng

Ubuntu 10.04 I have set MySQL to log slow queries and a general mysql log. How can I pipe those files in syslog to forward to centralized logging service (which is working)? Tried: source ...
1
vote
1answer
159 views

MySQL in Python broken in virtualenv after move to 12.04

This morning I upgraded my Xubuntu to 12.04. The virtualenv has moved up a version, and now bundles pip and I've had to rearrange some scripts to cope with this and rebuild my virtualenvs. MySQL ...
4
votes
1answer
940 views

Why was mysql-cluster removed from 12.04 and how can I install it?

I was hoping to get a MySQL cluster up and running on 12.04, but for some reason, the package is marked deleted, and there is no alternative. I also trying searching for the ndb_mgm command, and there ...
3
votes
0answers
3k views

MySQL Workbench for Ubuntu 12.04 LTS [duplicate]

Possible Duplicate: How to install MySQL workbench? MySQL workbench is not available for 12.04, it is at the moment available upto 11.04 only. I tried to install the Workbench 11.04 ...
0
votes
1answer
29 views

Installed program again in the “available to install” list

I have installed MySQL server and client from Ubuntu software centre. When I search for them from the dash home, they are listed under "Apps available for download" section. (If I search and find ...
1
vote
1answer
487 views

Upgrade MySQL to 5.5 on Lucid, upgrade server to Precise or switch to Percona?

Looking into upgrading mysql on our development server to which is running 10.04 so is stuck at MySQL 5.1, as it appears there is no apt-get support for upgrading to 5.5 except by certain 3rd party ...
3
votes
1answer
655 views

Run mysql queries in ubuntu 10.04 shell (cmd) stored in a files (desc order by filename)

I have a folder with about 40 SQL scripts with varying names, All using the pattern number description.sql. The file number consist of 2 digits and goes from 01 to 40, not all numbers in this range ...
0
votes
1answer
2k views

Boot order of MySQL

I have a conflict with two programs in Ubuntu 10.04. I have configured an init.d file that boots up a program. However, this program requires MySQL to be running before it starts. When I boot the ...
2
votes
1answer
4k views

Installing MySQL complete?

How I can install mysql in ubuntu 12.04(gnome 3). So that I will have my mysql installation in /usr/bin/mysql It's library and header files in /usr/lib/mysql and /usr/include/mysql respectively. ...
1
vote
2answers
3k views

How to remove MySQL completely with config and library files?

I tried everything till now: sudo apt-get remove mysql-server mysql-client mysql-common sudo apt-get purge mysql-server mysql-client mysql-common sudo apt-get autoremove and even more commands... ...
0
votes
2answers
5k views

running XAMPP does not work

i've tried to download XAMPP, untar it in /opt/lampp and launch sudo ./lamp start but i get this output: Starting XAMPP for Linux 1.7.7... XAMPP: Another web server daemon is already running. ...
1
vote
2answers
4k views

jdbc 4.0 in Ubuntu 12.04

I'm developing an application using Java and MySQL. I've installed libmysql-java package as a database connector, but the installed connector implements version 3.0 of the JDBC specification. Does ...
4
votes
1answer
757 views

Program uninstalled but still on list to remove

I have installed mysql-server-5.1 from terminal. Something went wrong and I had to uninstall it, done. When I type: sudo apt-get remove mysql double tab, it still give me a list with some mysql ...
2
votes
0answers
2k views

MySQL Workbench will not open on my Ubuntu 12.04

I have install mysql-workbench version 5.2.38+dfsg-3 via Ubuntu Software Center on my Ubuntu 12.04 laptop for some week ago, This work fine until now! Now when I press in the mysql-workbench icon ...
0
votes
1answer
449 views

How to access MySQL server with user password issued through LibreOffice Base frontend?

When dist-upgrading Ubuntu 11.10 to 12.04 UpdateManager asked to enter a "new" user password for MySQL. I denied 3 times. This asking was put misleadingly. I better should have entered a user password ...
0
votes
1answer
45 views

Upload breaks after 3203 Inserts

I upload a textfile with approx 30'000 lines into a Mysql-DB. The upload breaks allways after exactly 3203 lines. A splitted file with less then 3203 lines runs fine. The problem is, for sure, not ...
2
votes
1answer
5k views

mysql service do not launch

Sorry for my English; I was trying to create db with rake in RoR application that has been configured for MySQL(gem installed, settings changed). After that attempt mysql-server broke: d@calister:~$ ...
1
vote
1answer
2k views

Installing MySQL in ubuntu with putty

So...i'm trying to install MySQL Server in Ubuntu 10.04 (i don't want other version of ubuntu) and it don't works... I tried : sudo apt-get install mysql-server and also sudo apt-get install ...
3
votes
6answers
54k views

How to install MySQL GUI Tools in 12.04+ versions?

I want to install the MySQL GUI Tools in 12.04 and future version because frankly the way workbench works is not even close to how friendly the GUI tools were, specially for simple stuff like doing a ...
31
votes
3answers
41k views

How to keep apache and mysql from starting automatically

Is there a way to make apache and mysql not run automatically on startup? Currently, whenever I boot my machine, they start automatically and run in the background. I am using Ubuntu 12.04.
32
votes
4answers
54k views

Moving MySQL datadir

I am trying to move the data directory of my MySQL database to a second disk array that I have as a mount point /array2/. The problem I am having is I have tried everything and after I modify the ...
0
votes
1answer
176 views

xamppp lampp unistall and error

Today I installed xampp from their website and just downloaded and extracted on my linux os (using tar xvfz) command and I started it using /lampp start. everything started perfectly and I wanted it ...
3
votes
1answer
3k views

Can't install both libmyodbc and iODBC at the same time on Ubuntu 12.04?

I'm following this tutorial on Adding an ODBC driver to Ubuntu. I installed iODBC and then I went to install libmyodbc and noticed that it uninstalled iODBC, and now I can't follow the rest of the ...
0
votes
1answer
755 views

MySQL access via PHP doesn't find database

I installed apache2, php5, mysql-server, php5-mysql, phpmyadmin in that order on Ubuntu 12.04 with the Software Center. Apache and PHP works fine, no problems. Also, if I try to work with MySQL via ...
15
votes
1answer
11k views

how do I stop automysqlbackup throwing LOCK TABLES error?

How to stop automysqlbackup's cron.daily script -- as installed and configured from apt-get install automysqlbackup -- throwing the following error: mysqldump: Got error: 1142: SELECT,LOCK TABL ...
2
votes
2answers
13k views

Fixing broken myslq-server package after upgrade to 12.04

After upgrade to 12.04 mysql server was unable to start. I tried many different things but without any luck. Now when I try to install it, I get: $ sudo apt-get install mysql-server-5.5 Reading ...
1
vote
1answer
357 views

Failed to install Octave's database package on ubuntu [closed]

I'm trying to install octave's database package on my ubuntu machine. I had installed octave3.2-header before I installed the package, but some errors still exist. octave> pkg install ...
0
votes
1answer
465 views

How do I automatically backup Mysql-Cluster database?

I need to automatically and frequently backup Mysql-cluster databases. How can I do this?
0
votes
2answers
5k views

MySQL server stopped working after upgrade [duplicate]

Possible Duplicate: Fixing broken myslq-server package after upgrade to 12.04 I upgraded to 12.04 and my MySQL server just stopped working. It throws: ERROR 2002 (HY000): Can't connect to ...
1
vote
4answers
3k views

Mysqld not starting on boot?

After upgrading to Pangolin, mysqld is not starting on boot. I've looked into various other MySQL issues with the Pangolin release, and I haven't seen the same issue that other people are having ...
5
votes
2answers
13k views

Cannot install mysql-server (5.5.22) on clean ubuntu 12.04 LTS server

I have a clean minimal install of Ubuntu 12.04 LTS server 64-bit (just a root user and nothing alse installed). I tried to install the mysql-server with the following command: apt-get install ...
0
votes
1answer
1k views

MySQL Package problem after update

I recently installed the newest version of Ubuntu (12.04 LTS 32 bit). Afterward, I opened up Update Manager and got the following error: An unresolvable problem occurred while initializing the ...
26
votes
15answers
48k views

Can't start mysql - mysql respawning too fast, stopped

Today I did a fresh install of ubuntu 12.04 and went about setting up my local development environment. I installed mysql and edited /etc/mysql/my.cnf to optimise InnoDB but when I try to restart ...
2
votes
1answer
4k views

Is multiple mysqld processes for 1 mysql server is normal?

I'm not an server administrator, but i would like to know why on the server i have like 10 myslq instances? Is it good or bad? Does it negatively impact speed of my website? Here's screenshot: ...
0
votes
2answers
676 views

Recovering mysql database from an unbootable hard disk

We have installed a Linux Authentication Gateway (run on Ubuntu Server) for more than a year ago. It has several features built in upon install such as Squid, php5, mysql, etc. The thing is this: we ...
1
vote
1answer
588 views

12.04 upgrade stops at 'mysql restarting'

After downloading the upgrade started but the script stopped at 'mysql restarting'. What should I do now? The system doesn't launch any application and doesn't accept any commands. Should I reboot ...
0
votes
1answer
641 views

Errors when installing Mysql Server 5.1

I'm trying to install mysql server,and I'm getting the following error. sudo apt-get install mysql-server-5.1 Reading package lists... Done Building dependency tree Reading state ...
0
votes
2answers
3k views

innodb_buffer_pool_size not changing

I have encountered a weird problem with innodb_buffer_pool_size configuration on 5.5.23-1~dotdeb.0 (Debian): Whatever new value that I choose in my.cnf for innodb_buffer_pool_size (e.g 3G, 4G, ...
2
votes
4answers
2k views

After upgrading to 12.04 from 10.04, can't login to PHPMYADMIN

I just can't login to PhpMyAdmin anymore, it says bad logins. PHP works perfectly. Please help. Thank you. 2002 Cannot log in to the MySQL server Language Log in Username: Password: Connection for ...
43
votes
13answers
117k views

“Failed to spawn mysql main process: unable to execute: No such file or directory”

I'm a newbie on MySQL ground so bear with me. I've just finished upgrading 11.10 to 12.04. Everything seemed to work without any hiccups and all my software and settings are working fine. Apart from ...
0
votes
2answers
1k views

Move mysql data dir to TrueCrypt volume

I have Ubuntu Desktop 11.04 and I'm trying to move /var/lib/mysql to a TrueCrypt volume and am failing at every attempt. This is for development purposes, and there's a particular database I need to ...
0
votes
1answer
198 views

Does mysql comes with the default installation?

I have checked that I have mysql installed. Does it comes with the default installation ? I dont remember I have installed it. Installed files : mysql server core 5.1,mysql client core, mysql common ...
0
votes
2answers
8k views

etc/hosts setting for standalone MySql server

I am a little confused with setting up my new MySql server. It has to be a standalone server. Other webservers should connect to it. The hostname of the webserver is "webserver", the IP is ...
0
votes
3answers
1k views

MySQL error after rebooting (LAMPP)

I don't know if this is the right place to put this question. I installed Lampp and followed this instructions http://www.apachefriends.org/en/xampp-linux.html#377 and everything worked fine until i ...
1
vote
1answer
945 views

Different responses when telnetting into mysql's port via hostname

I'm trying to connect to mysql server installed on my computer. When I enter "telnet localhost 3306", I get some garbage characters meaning that I'm connected to the server. But when I enter "telnet ...
26
votes
6answers
56k views

Where are mysql-admin and query-browser?

In terminal I run next commands: sudo apt-get install mysql-server sudo apt-get install mysql-admin sudo apt-get install mysql-query-browser With first command - all ok. But for latest two ...
4
votes
2answers
5k views

Can't log into MySQL

Even after I reset the root password with the following command I cannot log into MySQL. (Other commands listed to provide additional info.) # sudo dpkg-reconfigure mysql-server-5.1 # mysql ...
0
votes
2answers
107 views

MySQL prevents server from booting unless password is entered

I am kind of new with Ubuntu but I have been working on setting up a LAMP server with hamachi as a vpn client for management. The issue is that when we turn the server on or restart it we are ...
1
vote
2answers
2k views

mysql server fails to start automatically at boot

If I start MYSQL cluster server with this command I get an error: root@v-server1:/usr/local/mysql-cluster# /etc/init.d/mysql.server start Starting MySQL The server quit without updating PID file ...
24
votes
4answers
233k views

How to change root password for mysql and phpmyadmin

I've set up mysql and phpmyadmin and chose not to set a password when installing hoping that once set up i could login with root and no password but i get the following error from phpmyadmin: Login ...