Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

3
votes
1answer
645 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
727 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
440 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
44 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
1k 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
52k 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 ...
27
votes
3answers
37k 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.
28
votes
4answers
49k 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
169 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
727 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
12k 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
348 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
428 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
2k 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
45k 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
640 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
567 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
616 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 ...
42
votes
13answers
114k 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
182 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
7k 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
899 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 ...
25
votes
6answers
54k 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 ...
22
votes
4answers
212k 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 ...
0
votes
1answer
582 views

Alternative way to start mysql server other than upstart?

I have a chrooted 10.04 LTS installation on a NAS, it works great but breaks Upstart very badly. MySQL only works via Upstart these days, so I created a workaround to start like this: dtach -n ...
2
votes
2answers
82 views

Need database selection advise

I know this is considered a bad question since there is no correct answer, but I need to decide on a database for embedded linux (DaVinci 368 based) hardware and I've never had to produce a design ...
4
votes
3answers
817 views

Really Broken MySql Setup

I have been having trouble with my MySql setup. This morning it was a working mysql server I added a database and some data with phpMyAdmin then things started to go wrong. I became unable to connect ...
3
votes
1answer
805 views

Backup MySQL databases from broken Ubuntu

Here is my problem, and I hope someone would help me to find a solution. My Ubuntu 12.04 is broken after an upgrade from 11.10, it won't boot up, just stops at the purple Ubuntu screen, but I can ...
1
vote
2answers
4k views

How to install mysql cluster?

How to install Mysql Cluster 7.1 or 7.2 on Ubuntu 10.11 ? On a fresh install of Ubuntu, we must uninstall pre-installed mysql before? What is the best way, use .tar.gz on Mysql Website with or witout ...
0
votes
1answer
695 views

Connect to MySQL on remote server from inside python script (DB API)

Very recently I have started to write python scripts that need to connect few databases on mySQL server. The problem is that when I work from office my script works fine but running a script from my ...