Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

5
votes
2answers
4k views

MySQL change datadir, problem with mysqld.sock

I tried to change the database directory, datadir, I did the following steps. My machine: Laptop Ubuntu 11.10 64-bit Install: sudo apt-get install mysql-server mysql-client All Ok, I can create ...
0
votes
2answers
660 views

MySQL Administrator asks for password every time

I have instlaled MySQL Administrator and it works fine, except one annoying thing. Every time i select a table and click 'Edit Table Data' from context menu, it prompts for password. Any idea how to ...
0
votes
1answer
2k views

MySql is not starting xampp on ubuntu

I have recently migrated to ubuntu and I have intalled Xampp for Ubuntu .. lampp as per the instructions mentioned on xampp website, i have installed the lampp lampp Installation And it was starting ...
0
votes
1answer
2k views

MySQL doesn't start due to a missing binary

I need to install mysql 5.6 on my ubuntu machine for development reasons (the newest version contains features that I need to incorporate into some web projects). But I am having some issues. I've ...
2
votes
1answer
5k views

Connecting to MySQL in Bash (without MySQL installed)

I am trying to connect to a remote MySQL database in Bash. On the server hosting the database I can type: mysql -u _username_ -p to connect. I would like to be able to type: mysql -h _host_ -u ...
9
votes
4answers
32k views

How do I start the MySQL console in XAMPP?

The XAMPP installation is done. XAMPP is up and running. What about the MySQL console? How is possible to start the MySQL console to run some special SQL statements?
0
votes
1answer
2k views

Install mysql 5.6 from RPM [duplicate]

On my Ubuntu 11.10 (64bit) I has installed MySql server 5.1 which installs automatically, from synaptic. For some reason I find that I need upgrade to version 5.6 but I can't find .deb file for do ...
0
votes
5answers
14k views

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

I've been struggling with this issue for a really long time. Can someone please advise me on how to get mysql working? root@me:~# start mysql start: Job is already running: mysql root@me:~# mysql ...
1
vote
2answers
10k views

mysql problem '/var/run/mysqld/mysqld.sock'

I got this error on my php script with db: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) and on phpmyadmin: #2002 Cannot log in to the MySQL server What is ...
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
442 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 ...
53
votes
4answers
349k 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
511 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
542 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
24k 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
764 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 ...
15
votes
3answers
10k 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
17k 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
8k 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
18k 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
872 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
322 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
851 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
429 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
813 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
789 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
568 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 ...