An open-source, relational database management system.

learn more… | top users | synonyms

0
votes
1answer
278 views

Force users to change email password every six months

I'm going to build an experimental mail server with Postfix + Dovecot and Mysql for user accounts. The server will offer SMTP + POP3 + IMAP. Is there a way to force users to change their mail account ...
1
vote
0answers
205 views

Force mysqldump encoding

I have two mysql servers, viewed from the same mysql client, right_server is rendering the french characters correctly, wrong_server is not. Encoding is the same : $ mysql -h right_server -NBe "SHOW ...
3
votes
3answers
799 views

Encrypt a password the same way mysql does

I've created a user ... but forgotten the password mysql> create user 'blayo'@'%' identified by 'right'; Which Linux command line tool can encrypt the password the same way mysql 5.5 does ? ...
3
votes
1answer
831 views

Convert mysql count(*) to int in bash?

I'd like to execute this and check if count is 0, 1 or > 1 in bash. mysql -e "select count(*) from mydb.mydb;" The output is: +----------+ | count(*) | +----------+ | 0 | +----------+ I ...
1
vote
2answers
1k views

How to allow mysql remote connections via particular interface

I have a 10.237.49.251 IP on eth0 and another IP on another interface How do I enable remote mysql calls on eth0 device?
3
votes
2answers
451 views

Error establishing a database connection; how can I determine whether or not these connections are real?

I've just run into a problem today with MySQL reaching its database connection capacity. The error I'm receiving is, Error establishing a database connection. When I try to access /phpma, I get this ...
1
vote
1answer
922 views

How to fix this mysql permission problem?

I'm trying like mad to get rails dbconsole to work (Rails 3.2.6, if that helps). The problem is that when I run the command, I get: gems/railties-3.2.6/lib/rails/commands/dbconsole.rb:81:in `exec': ...
3
votes
2answers
359 views

Trying to create tunnel to mysql through SSH

Im in a bit of a bind here. I have a client that want's me to set up his website, but he runs the server w/ SSH and CentOS 6.2 as it's OS. Now, I'm trying to add the sql server on Mysql Workbench for ...
0
votes
3answers
235 views

Why “Linux Generic” use RPM extension in MySQL download page?

I need to install MySQL 5.5 from source in Ubuntu 10.04. So I'm trying to find tar.gz source from here. But when choosing "Linux Generic" from the drop down menu, it is showing an RPM extension I ...
3
votes
3answers
530 views

How to force rpm to check dependencies during upgrade?

We have a current version of our software that has a dependency on MySQL 5.1 and this is specified in the RPM requires. For our new version, we now require MySQL 5.5 and specify this in the RPM ...
4
votes
4answers
5k views

How can I check if mysql is installed using a bash script?

I need to check if mysql is installed from within a bash script. What would be an efficient way of doing that? I thought I could do this: if [ ! -f `which mysql` ] ; then echo "foo" fi But I ...
1
vote
1answer
203 views

How to purge package in debian without affecting other packages?

I had mysql-server-5.1 installed, then upgraded to mysql-server-5.5 and now upgraded to percona server (package percona-server-server-5.5). So now I have 2 mysql-server packages removed, but not ...
1
vote
3answers
3k views

Where, in automysqlbackup, do I add mysqldump parameters?

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 ...
1
vote
1answer
888 views

Why can't I run mysql?

I'm trying to import a database from Wamp to Xampp. I run Lampp first, then go to /opt/lampp/bin and run: mysql (or mysqladmin ?) -u root -h localhost but I get: mysql: command line not found ...
6
votes
2answers
319 views

Back up mysql server

I want to backup all databases, users and etc on our mysql sever. I have come across the command mysqldump and believe I can use it like this? (Trying to backup a REMOTE server to our LOCAL machine) ...
0
votes
1answer
826 views

Install Mysql 5.6.4 or greater on web server with on CentOS / openSUSE with Plesk 10

I need to install MySQL 5.6.4 or greater on my web server because I'm using the full text innodb feature. I'm trying to move my local installation (WAMP server) to my dedicated server and I'm not able ...
7
votes
5answers
3k views

Fedora 16 strange /tmp permissions: mysqld will not start

I installed mysql on a brand-new Fedora 16 server and it would not start. This is the line from the log file (^G and all): ^G/usr/libexec/mysqld: Can't create/write to file '/tmp/ibNPyIlu' (Errcode: ...
6
votes
2answers
2k views

Get a progress indicator when importing MySQL databases

I often import MySQL databases, and this can take a while. There is no progress indicator whatsoever. Can one be shown, somehow? Either records imported, MB imported, or tables imported... anything is ...
9
votes
1answer
496 views

MySQL gets killed by OS every 25 days or so

About 4 months ago we migrated from MS SQL Server to MySQL 5.5. Since then we have been experiencing an issue once approximately ever 25 days since where CentOS runs out of memory and as a result it ...
1
vote
1answer
199 views

fedora can't find mysql service

I have a VPS running Fedora 16 (upgraded from 15). Mysql was installed and working until recently. Now I can't get the mysql service started. when I try /etc/init.d/mysqld start I get the error ...
1
vote
0answers
922 views

Fedora Failed to get D-Bus connection

I have a VPS with fedora 16 installed. I have setup mysql and it was working a couple of days ago. Now suddenly when I try to start mysql I get the error: Failed to get D-Bus connection: Failed to ...
0
votes
1answer
186 views

How to use a password as an external variable in shell?

I have this MySQL backup script that I use to back up MySQL databases. Very useful, and it runs on fixed intervals using a cron. However, I need somehow provide this script with the MySQL password. ...
5
votes
3answers
4k views

Will yum remove mysql-server delete my databases?

My MySQL server has broken down, and I can't figure out why. Trying to do a yum reinstall I get this: Error: mysql-server conflicts with mysql-server I figure that's because the server already had ...
1
vote
2answers
625 views

How would I direct local(127.0.0.1) MySQL traffic to an external SQL server?

Basically, I have two EC2 instances on Amazon Web Services. They are both running Ubuntu 11.10 x64. They both have a private and a public (Elastic) IP addresses. I'm having trouble setting up iptables ...
1
vote
2answers
503 views

Script that uses MySQL query to automatically remove output

I have this query that outputs updates older than 7 days from a database. How would I make a script that takes the MySQL statement and puts it into a script to be executed by cron. echo "select name, ...
1
vote
2answers
119 views

Find all postgresql and mysql databases on a system

Is there a way to find all postgresql and mysql databases on my system? (Perhaps using the find command).
2
votes
1answer
674 views

How to script a database migration using SSH?

I am trying to create a sync.sh script that coordinates with our less-than-ideal version control for our website. This script will migrate a copy of the live database to our local development ...
0
votes
2answers
499 views

phpmyadmin 403 error

i mannually installed phpMyAdmin according to this doc:quick install.but i keep getting the 403 error, i can successfully get into other folders in the root dir, how can i sovle this? here is my ...
0
votes
2answers
3k views

MySQL table is repeatedly crashing

I have xen virtual machine (Debian stable in PV mode) and I've Joomla on it. Several times in a day I see this message on the front page of my site. jtablesession::Store Failed DB function failed ...
5
votes
5answers
886 views

Multiple ssh sessions in single command

I'm trying to copy a database from one server to another. I tried using the following command and it's getting tied up on entering the ssh passwords. If I put in one server's password, it complains ...
0
votes
1answer
358 views

Installing glibc 2.3 for mysql server

I need to install mysql server and client for a project of mine so I downloaded the MySQL-client-5.1.61-1.glibc23.i386.rpm for the client and MySQL-server-5.1.61-1.glibc23.i386.rpm for the server. I ...
0
votes
1answer
835 views

How to easily maintain the latest versions of Apache/ MySQL/ PHP on CentOS 6.2?

We have a few servers running CentOS 6.2 deploying web applications using Apache/ MySQL/ PHP. In the past we've just regularly run "yum update" to keep all the software up to date. As of right now ...
4
votes
1answer
1k views

How can I determine the connection method used by a MySQL client?

When using a MySQL client (e.g. mysql) how can I determine whether it connected to the server using a Unix socket file or by using TCP/IP?
1
vote
1answer
1k views

Why don't I see the XAMPP page on Linux Mint?

I am trying to install PHP MySQL on Mint 12. I downloaded and installed XAMPP. According to the tutorial, when I go to localhost in a browser I should see this: Instead, I see: It works! This is ...
4
votes
1answer
128 views

If I'm logged in as root, how do I restart mysql or apache with options?

I know the commands to restart/stop/start, but when I try to pass options it doesn't seem to work! CENTOS 6, MySQL 5.14 service mysql restart service httpd restart Then I tried this: ...
2
votes
0answers
1k views

MySQL socket and PHP (and other languages)

Background info I'm currently running CentOS (or Red Hat?). uname -a gives (I edited out my domain name) Linux XXXXXXXXX.com 2.6.32-71.29.1.el6.x86_64 #1 SMP Mon Jun 27 19:49:27 BST 2011 x86_64 ...
1
vote
2answers
3k views

Can't start mysqld

I've installed mysql through $ sudo apt-get install mysql-server-core-5.1 $ sudo apt-get install mysql-client-core-5.1 This is my current conf file And the service won't start, at first the ...
3
votes
1answer
2k views

How to enable an federated storage engine in the Debian MySQL package?

How would I enable an extra (in this case FEDERATED) storage engine in the mysql-server-5.1 package from Debian? I've installed mysql-server-5.1 via apt-get. But the SHOW ENGINES shows that federated ...
0
votes
2answers
371 views

How do I install software on Fedora 13?

I installed Fedora 13, but it doesn't come with a lot of software I want -- office tools, productivity, GUI environments, MySQL, and Kamailio. How do I get all this stuff onto my Fedora install?
2
votes
2answers
2k views

How to grant a “no-root-user” rights to start/stop/restart mysql server on suse machine?

Is it possible to grant priviliges to a "no-root-user" to start and/stop/restart the mysql server on a suse machine? The goal is to make it for a developer possible to tune a mysql server/database ...
5
votes
1answer
12k views

How can I completely reinstall mysql?

I had to reboot in the middle of a large data import. I only have one mysql database, which has now been corrupted. How can I completely remove mysql and reinstall it? I've tried apt-get purge ...
2
votes
1answer
2k views

Brute force access to a Firebird database?

Ok, so here's the deal. When migrating a certain product with terrible documentation to another database type, my Firebird database was deleted. I then proceeded to recover it from the filesystem ...
1
vote
0answers
463 views

Can't make a copy of /var/lib/mysql/ibdata1

I have a RedHat Linux server and I'm trying to make a copy of /var/lib/mysql/ibdata1, but I'm receiving an error saying permission denied and the file cannot be opened. I'm logged in as root user and ...
1
vote
3answers
943 views

Error dropping database in MySQL 5.1 on Ubuntu

I am using MySQL v5.1 on Ubuntu machine. I have a database named my_db which I would like to drop it, so I execute command: mysql> drop database my_db; ERROR 1010 (HY000): Error dropping ...
1
vote
4answers
1k views

Restart MySQL server

I am using MySQL v5.1 on Ubuntu machine. MySQL on my machine used to work. (Running mysql -u root gave me the MySQL command line.) This afternoon, I did the following thing: 1. check active process ...
3
votes
2answers
2k views

'mysql' user and group creation, ownership settings

I know what the linux command chown does, I used it to change the ownership or group of a file. If there is a MySQL installation on a Ubuntu machine, I saw some people doing the following thing: ...
1
vote
2answers
2k views

MySql: LOAD DATA INFILE

I am using MySQL v5.1 on Ubuntu machine. MySQL data directory is /var/lib/mysql/ I have a test.dat file located on /var/lib/mysql/tmp/test.dat I would like to load data from the test.dat file into ...
2
votes
1answer
493 views

Linux : Alternative of install_name_tool of MAC in CentOS

I am looking for alternative of install_name_tool of MAC in CentOS. Exactly I want to build MySQL on non default location. Also the shared libraries of the mysql binary should be on non default ...
1
vote
1answer
65 views

dump out some tables of the database

I am using MySQL v5.1 on Ubuntu machine. I have a database named db_test which contain tables like cars, customers, departments, prices , and so on. I know I can use the following commands to dump ...
2
votes
2answers
4k views

Can I copy a MySQL database by copying the files? What do the files contain exactly?

I am using MySQL database and using an Ubuntu Linux machine. My database named db_test , I notice that under path /var/lib/mysql/db_test ,there are files suffix with .frm, .MYD, .MYI like following: ...