Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

5
votes
3answers
1k views

Which is the easiest way to reset the mysql root password?

In the past there has been sudo /etc/init.d/mysql reset-password, (1) is manually restarting and setting the password with an sql command again required? (2) (1) ...
2
votes
2answers
4k views

Error while installing mysql-server-5.1

I need to install mysql-server-5.1 on ubuntu 11.10. While installing with apt-get I am getting dpkg: error processing mysql-server-5.1 (--configure): subprocess installed post-installation script ...
6
votes
1answer
4k views

How do I set up Mysql Cluster?

I am trying to setup mysql-cluster-gpl-7.1.17-linux-i686-glibc23.tar.gz on ubuntu 10.04 server for the past 3 weeks and not successful yet. The links I followed are: ...
3
votes
0answers
640 views

Create my own unity lens [duplicate]

Possible Duplicate: How do I start developing a lens for Unity? Is there any easy way of creating a unity lens without any big programming knowledge? I can code in php, mysql, html and all ...
1
vote
1answer
433 views

Adding user with custom home directory, and setup mysql user/password

I want to have a way of easily adding users with a custom home directory. Also setting up an FTP & MySQL Username/Password. How might be an good way of doing that? I am thinking something like a ...
49
votes
4answers
327k views

How do I start/stop mysql server?

I try find in internet some article where describe how correct start -stop mysql server. I find this article: How to start/stop MySql server on Ubuntu 8.04 | Abhi's Blogging World I run this ...
1
vote
1answer
501 views

Where to apply these akonadi settings for mysql-server?

I Am using an external mysql-server to work with akonadi. (using KDE4). Now I could solve all problems with it, but I still have to apply some settings to the "mysql-global.conf"-file of the server. ...
0
votes
3answers
539 views

MySQL database in tasksel LAMP stack for osCommerce

I'm experimenting with osCommerce, an e-commerce suite, for which I installed the LAMP stack using tasksel. It did ask for a "root password" for MySQL, but other that that I did not pay attention to ...
2
votes
5answers
23k views

how can i log in to MySQL

I am new to ubuntu and installed MySQL use a rpm file, and started it use sudo start mysql, when i try mysqladmin -u root password test I get mysqladmin: connect to server at 'localhost' failed ...
1
vote
2answers
763 views

Where do I put my start up script for mysql?

I have created a second instance of MySQL on the server for replication, if I start the process manually it works but need it to start at bootup. I used to just do a bash script in the init.d folder ...
14
votes
3answers
9k views

How do I install MySQL without a password prompt?

I'm trying to install MySQL on Ubuntu Natty without the password prompt. However, I keep getting prompted for a password at some stage after the main installation. Also, when I do enter what I ...
7
votes
5answers
72k views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have mailserver configure using dovecot+postfix+mysql and it was runnig fine in the server(Ubuntu Server). But during last week it stopped working correctly. It doesn't send email. When I try to ...
1
vote
1answer
1k views

Can't get MySQL workbench to work

I've installed Ubuntu 11.10 and can't seem to get MySQL workbench to work. I have tried installing both versions from the website by downloading the .deb files for ubuntu 10.04 and 11.04, but both ...
4
votes
1answer
2k views

How to install php 5.3.8 and mysql 5.5?

What is the best way to install mysql 5.5 with php 5.3.8 (latest version)? as most of common repositories have only older versions.
0
votes
0answers
545 views

Upgrade to mySQL 5.5 on Ubuntu 11.04 [duplicate]

Possible Duplicate: How do I upgrade MySQL to 5.5, am I best off waiting for it to be available through apt-get? I've seen that mySQL 5.5 has a lot of innoDB performance enhancements. Is ...
2
votes
2answers
2k views

MySQL 5.5 PPA Trustworthy?

I found this PPA which features MySQL 5.5 (alongside php 5.3.8 packages..): https://launchpad.net/~nathan-renniewaldock/+archive/ppa Seems to be working fine on my 11.10 Ubuntu, ut I can't find ...
3
votes
3answers
6k views

I just installed Mythbuntu, what is the MySQL root password?

After installing Mythbuntu, I am unable to access MySQL as I don't remember setting a root password. What is the default password?
4
votes
2answers
16k views

mysqld gives errcode:13 because it can't create test files

New installation of 11.04. Then I followed all instructions here: http://www.howtoforge.com/installing-apache2-with-php5-and-mysql-support-on-ubuntu-11.04-lamp Now when I run mysqld I get this error: ...
3
votes
3answers
7k views

Is an easy way to import .dbf file contents into MySQL in terminal

I've got this files: /referencias$ ls | grep .dbf avenidas.dbf barrios.dbf borde.dbf construcciones.dbf espejo_de_agua.dbf manchas_urbanas.dbf manzanas.dbf plazas.dbf I want to do but in the ...
14
votes
2answers
21k views

My MySQL installation is broken. How to completely reconfigure it?

Here are the following commands I have done. $ sudo service mysql start mysql start/running $ mysql -u root ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
8
votes
9answers
6k views

mysql-workbench only shows splash screen when being launched

I've downloaded mysql-workbench 5.2.35 and installed it, but when i run it, it shows only the splash screen, nothing more.
2
votes
2answers
2k views

Why can't I telnet to MySQL?

When trying to connect to mysql server via telnet I am getting following error: telnet localhost 3306 Trying ::1... Trying 127.0.0.1... telnet: Unable to connect to remote host: Connection timed out ...
0
votes
2answers
2k views

“SQL engine 'mysql' not supported” with saslauth

I'm having trouble authenticating incoming SMTP authentication to my postfix server (using Cyrus SASL with a MySQL backend). In my auth.log I get: postfix/smtpd[3389]: sql auxprop plugin using mysql ...
0
votes
1answer
215 views

Is it possible / avaliable to Upgrade to MySQl 5.5 [duplicate]

Possible Duplicate: How do I upgrade MySQL to 5.5, am I best off waiting for it to be available through apt-get? Upgrade to MySQL version 5.5? If so. It is not in the synaptics package ...
0
votes
2answers
3k views

How can I load xml through mySql?

On Windows (r) I can this statement to load xml data in the database LOAD XML LOCAL INFILE 'c:/users/yourname/desktop/myfile.xml' INTO TABLE MyTable ROWS IDENTIFED BY '<product>' But, I ...
7
votes
1answer
17k views

How do I enable the mod_rewrite Apache module for Ubuntu 11.04?

In other linux like CentOS, it works but i am not getting it running in Ubuntu 11.04. /var/www/html/folder/public/.htaccess: Invalid command 'RewriteEngine', perhaps misspelled or defined by a module ...
0
votes
2answers
859 views

Terminal says 'Broken package' when using apt-get to install phpMyAdmin

I have tried to install phpMyAdmin using the sudo apt-get install phpmyadmin command> The terminal says that there are "uninstallable" dependencies, therefore the package is broken.Perhaps the ...
3
votes
3answers
315 views

What to use to monitor MySQL for corrupted tables?

What is a good program to monitor mysql tables for corruption, one that would email me as soon as there is a corrupted table? I'm not looking for mysql workbench or admin to manage the database. But ...
1
vote
2answers
818 views

Having a problem to send message to gmail from our mail server

We use Ubuntu Server and in a days I have installed and configured Postfix+Dovecot+MySQL as it is explained here. From that tutorial I escaped creating certificates and antispam application. Right now ...
2
votes
1answer
185 views

Is there a solid howto for replacing MySQL with Maria in the LAMP stack?

I've heard great feedback on a few folks migrating production machines (including from this question), and I'd like to test the transition in our dev environment. Maria is apparently in the 11.10 ...
2
votes
1answer
1k views

MyODBC with MySql in Ubuntu 11.04

I want to read mysql table data to an excel file. So I decide to install MyODBC in my Ubuntu 11.04 with these command lines: sudo apt-get install iodbc sudo apt-get install libmyodbc I start the ...
1
vote
0answers
419 views

MySQL upgrade options for 11.04? [closed]

As of yesterday I have brought up a new website running on Ubuntu 11.04 (on Linode). The customer was unhappy with the previous vendor and I have brought across their Django site, moving from Python ...
6
votes
5answers
7k views

How to stop mysql from running at boot time?

How could I stop Mysql from running at boot time? Is there any GUI for that or this must be done through console? It's Ubuntu 10.10
3
votes
4answers
6k views

Problem installing mysql, error in post-installation script

Having problems loading/installing mysql Here is the output while installing: mysql-server-5.1 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. Need to get 0 B/6,258 kB of archives. ...
5
votes
1answer
6k views

Where are the MySQL InnoDB log files stored?

I changed some settings for my InnoDB tables in MySQL and encountered the problem that InnoDB was not shown in SHOW ENGINES output. As an answer I got the suggestion to delete the log files of InnoDB. ...
1
vote
2answers
6k views

Installing old MySQL server 4.1 on Ubuntu 11.04

how do I need to install mySQL server 4.1 on Ubuntu 11.04 server for a legacy app to run (it breaks on mySQL 5). sudo apt-get mysql-server-4.1 doesn't work - "package is missing, obsoleted or ...
1
vote
2answers
803 views

phpmyadmin installed but not opening? [duplicate]

Possible Duplicate: phpmyadmin is not working after I installed it I have ubuntu 11.04. I installed lamp So i automatically got things like mysql , php , apcahe which are needed for it. ...
2
votes
1answer
6k views

Installing MySQL 5.1

this question is surely a dupe of http://stackoverflow.com/questions/1632056/how-do-you-install-mysql-5-1-on-ubuntu-8-10 Since I can't comment on that one...I am starting a new one. I'm having the ...
7
votes
3answers
768 views

What to install for mysql?

I am going to learn mysql by myself, so I would like to install mysql on . But there are many applications related to mysql in synaptics. I was wondering what are some basic applications to be ...
0
votes
2answers
1k views

Having problems getting LAMP installed

Okay, this is like my fifth time trying to get LAMP set up on Ubuntu, and yes, that includes using XAMPP. (All I want to do is practice my PHP so I can write WordPress plugins! sob Why does the ...
5
votes
1answer
555 views

File access: open fails for one program but not another

This is the most unusual thing. I'm trying to start up mysqld with a different my.cnf (so I can have two MySQL daemons running without conflict). The file is /etc/mysql/my2.cnf but mysql won't open ...
-1
votes
4answers
8k views

How do I start/stop mysql in XAMPP?

I installed XAMPP. Now the problems are I can not start mysql root@ubuntu:/# sudo /opt/lampp/lampp startmysql XAMPP: Starting MySQL... XAMPP: Couldn't start MySQL! I can not put my projects so i can ...
2
votes
1answer
3k views

Problem running multiple MySQL instances

I'm trying to run multiple instance of mysql 5.1.49 on ubuntu 10.10 to setup a replication/backup database. I have added following line to /etc/mysql/my.cnf: [mysqld2] server-id = 2 socket = ...
4
votes
1answer
7k views

How do I enable my innodb

I need to enable innodb on my ubuntu server 10.04 and having tons of problems, I have tried posting questions everywhere and I have no answers....i tried this show variables like "%innodb%"; ...
2
votes
2answers
401 views

lamp-server wants to install mysql but i want it to use already installed MariaDB

i want to install lamp-server in ubuntu 10.10 (the end goal is to install redmine), i am using sudo tasksel install lamp-server However after downloading packages it asks for a root password for ...
1
vote
2answers
539 views

Backing up MySQL Database (Up to a month or while theres space)

I am backing up my files using deja-dup. But how do I do the same with MySQL? I see some cron scripts, but that will keep backups forever. I thought the feature of deja-dup that allows backups to be ...
3
votes
1answer
3k views

Is MySQL server installed by default?

I have a fresh installation of Ubuntu 11.04. Since I want to work with a MySQL server on this machine I see, that if I enter mys in the terminal and hit TAB it completes to mysql. But if I do mysql -u ...
21
votes
7answers
65k views

How to install MySQL workbench?

Installing MySQL workbench on 10.04 or 10.10 is not a problem, as the deb packages are available on MySQL's website. But there is no 11.04 deb package available. So, how do I install MySQL workbench ...
1
vote
2answers
1k views

Issues with Java's JDBC (MySQL) for linux - Crontab job causes connection failure in java program, but when run manually is fine

So as the title states, Ive got an issue with Crontab and my Java program connecting to a remote MySQL database. The program itself is quite simple: it connects to the database, grabs two tables ...
6
votes
1answer
8k views

How can I export MySQL database manually - without phpmyadmin [closed]

My phpmyadmin doesn't work, i see only white blank page when i open it(it's has some issue), However, I'd like to export my project databased manually to another computer. i saw all my databases ...