Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
1answer
920 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
55k 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
4k 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
1k 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 ...
23
votes
4answers
221k 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
590 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
827 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
826 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
715 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 ...
0
votes
1answer
495 views

How to determine what configuration options were used for MySQL server from Ubuntu Packages?

How can I get compilation options that was used for mysql-server from Ubuntu packages? I fetched sources using: apt-get source mysql-server But I have to run configure: ./configure Only then I ...
3
votes
2answers
682 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
956 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
435 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
4answers
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
379 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 ...
11
votes
3answers
15k 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
753 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
248 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
105 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
121 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
3k 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 ...
5
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
734 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
1k 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
6k 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
37k 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
1k 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
3answers
12k 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
459 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 ...
65
votes
4answers
428k 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
549 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
564 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
28k 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
766 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 ...
17
votes
3answers
11k 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
74k 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
1k 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 ...