Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

5
votes
1answer
6k views

Mysqli for PHP in package mysql

I am trying to get mysqli set up for php5 but apt tries to substitute php5-mysql for php5-mysqli, which doesn't exist. Does the mysql package also carry the mysqli extension, or do I need to find the ...
1
vote
2answers
3k views

MySQL starting error

I installed LAMP not so long ago and it worked fine but ever time I try start MYSQL server I see this thing: $ /etc/init.d/mysql start Rather than invoking init scripts through /etc/init.d, use the ...
3
votes
1answer
19k views

#1045 Cannot log in to the MySQL server

I am totally new in linux/ubuntu I am trying to setup lamp on my OS, however I've installed apache , php , mysql by following commands: sudo apt-get install apache2 sudo apt-get install php5 sudo ...
0
votes
3answers
966 views

MySQL and PHP problems

I'm new in server-side programming. I need lampp and mysql running on my computer. I have installed mysql using tasksel lamp-server, and then install php with apt-get install libapache2-mod-php5 ...
0
votes
1answer
2k views

Unable to login using new mysql user added via phpmyadmin

On my computer yesterday I installed 12.04 and applied all updates. I have installed lamp on this system using following command sudo apt-get install lamp-server^ phpmyadmin . I created a new user ...
1
vote
2answers
2k views

Mysql not starting - innodb not found

I have a fresh install of ubuntu 12.04 server edition and mysql server is not starting properly. I did a simple apt-get install apt-get install mysql-server But, it's failing with this error ...
0
votes
2answers
3k views

MySQL version to be used on Ubuntu 10.04

I've a production server and a test server both having Ubuntu 10.04.4 LTS When I installed MySQL on test server, I just run apt-get install mysql-server and 5.1.62-0ubuntu0.10.04.1 got installed ...
2
votes
2answers
137 views

mysql ubuntu noinstall

I am looking for MySQL "no-install" version for Ubuntu. I can successfully run MySQL on Windows (using MSI Installer as well as no-install). With Ubuntu, MySQL got installed using the software center. ...
1
vote
4answers
2k views

How to get MySQL back on Ubuntu 12.04?

The upgrade to Ubuntu 12.04 delete MySQL and I need urgently to get it back. The problem is that I'm getting an error installing it, either with apt-get or aptitude: Errors were encountered while ...
0
votes
1answer
932 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
154 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
905 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
458 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
607 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
1k 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
3k 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
3answers
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
4k 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
3k 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
669 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 ...
1
vote
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
418 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
43 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
50k 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 ...
19
votes
3answers
31k 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.
23
votes
4answers
40k 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
162 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
645 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 ...
12
votes
1answer
9k 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
325 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
374 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 ...
22
votes
14answers
40k 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 ...
1
vote
1answer
3k 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
596 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
526 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
562 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 ...
36
votes
13answers
105k 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 ...