Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

3
votes
2answers
518 views

Mysql not working after apache2 reinstall?

Earlier I had a problem that had to do with .htacess files but I got that fixed but in the process I thought it would be good to re install Apache2. That fixed all web server problems, but when I ...
2
votes
1answer
792 views

How to debug a server that crashes once in a few days?

One of my servers crashes once in a few days. It does low traffic static web serving + low trafic dynamic web serving (PHP, local MYSQL with small data, APC, MEMCACHE) + some background jobs like XML ...
0
votes
1answer
388 views

Install OSSEC HIDS In Ubuntu Generate Error

I work with OSSEC HIDS In Ubuntu 11.10: http://www.ossec.net/wiki/Know_How:DatabaseOutput When install with mysql support, it back me this error /tmp/ccuS4FYw.o: In function mysql_osdb_connect': ...
0
votes
3answers
3k views

Cannot start XAMPP

When I try to start XAMPP with /opt/lampp/lampp start command it gives me a message like this. Starting XAMPP for Linux 1.7.7... XAMPP: Another web server daemon is already running. XAMPP: ...
2
votes
3answers
294 views

How to disable mysqld in 10.04?

I have a few (Linode) Ubuntu 10.04 (64bit) VPSes, and mysqld keeps starting on every reboot on all of them -- $ uptime 16:32:26 up 1 min, 1 user, load average: 0.09, 0.08, 0.07 $ ps -ef | grep -i ...
2
votes
3answers
1k views

What is the easiest, most effective backup system for Ubuntu Servers?

I'm trying to backup my /var/www/ folder, MySQL, and any other special documents like in the /etc/apache2/ folder. Does anyone have any solutions for backup software? Maybe something that's ...
10
votes
3answers
9k views

MySQL 5.5 starts and then instantly stops

MySQL 5.5 on Ubuntu 10.10 used to work well until yesterday but today whenever I start MySQL using mysqld_safe as root user it shows Starting mysqld daemon with databases from /var/lib/mysql and ...
2
votes
1answer
581 views

Package error while trying to upgrade mysql-server

I am trying to upgrate mysql 5.1 to version 5.5 Since official ubuntu repositories do not provide 5.5, I've decided to go with Dotdeb repository. When I've updated the package information and typed ...
-1
votes
1answer
220 views

Best approach to automatically processing .csv --> MySQL [closed]

Bump this to the proper place if necessary. Not sure where I can get the best response. I need to create a reporting application and would like to do it with Ubuntu if possible. The originating data ...
1
vote
1answer
104 views

How to upgrade MySQL to >=5.1.51 on Lucid via aptitude

The mysql-server package in Lucid is listed as 5.1.41-3ubuntu12.7. Is there a safe way to upgrade to the latest 5.1 release via aptitude?
0
votes
1answer
115 views

Can I run Apache2 as my user on my Ubuntu for development purposes? [duplicate]

Possible Duplicate: Whats the simplest way to edit and add files to “/var/www”? Should I as a developer use var/www in conjuction with apache? I've gone and re-installed ...
2
votes
1answer
2k views

Take text from a file and insert to a mysql table using a script

I would like to take data (some text) from a file and insert it into a mysql field, using a script. I have tried: mysql -u root -p password dbname << INSERT INTO tblename (fieldname) VALUES ...
4
votes
2answers
3k 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
523 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
4k 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 ...
6
votes
4answers
23k 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
4answers
11k 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
8k 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
411 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 ...
36
votes
4answers
244k 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
454 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
506 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 ...
3
votes
5answers
17k 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
761 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 ...
13
votes
3answers
7k 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
69k 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
544 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
5k 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
15k 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
18k 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
214 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
2k 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 ...
6
votes
1answer
12k 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
797 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
291 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
667 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 ...