≡ Menu

mysql server

HowTo: Uninstall MySQL Server in Ubuntu Linux

I'm a new Ubuntu Linux user and my cloud hosting company installed MySQL server by default. I need to remove it and delete it from my server as I have no use of MySQL server. How can I uninstall MySQL on a Ubuntu based systems?
[click to continue…]

mysqldump: Copy Database Using Shell Pipes

How do I use mysqldump command with Unix shell pipes?
[click to continue…]

[ERROR] /usr/local/libexec/mysqld: unknown variable ‘thread_concurrency=8’

I'm trying to set 'thread_concurrency to 8 under Linux MySQL server. But when I try to restart the mysql server, I get the following error:

[ERROR] /usr/local/libexec/mysqld: unknown variable 'thread_concurrency=8'

How do I fix this problem?
[click to continue…]

MySQL Import File / Database Command

How do I import data stored in a .sql file created by mysqldump command on Linux or UNIX like operating systems? How do I restore mysql database backup using bash shell based command line option?
[click to continue…]

ERROR 1018 (HY000): Can’t read dir of ‘./dbname/’ (errno: 13)

When I run the following command at mysql> I get an error which read as follows:

mysql> use dbname;
mysql> show tables;
ERROR 1018 (HY000): Can't read dir of './dbname/' (errno: 13)

How do I fix this problem under Debian Linux?
[click to continue…]

Lost MySQL Admin Password

I lost mysql admin (root user) password. How do I reset a lost MySQL admin (root) password under UNIX or Linux or BSD operating systems?
[click to continue…]

MySQL Bin Files Eating Lots of Disk Space

Q. I get a large amount of bin files in the MySQL data directory called "server-bin.n" or mysql-bin.00000n, where n is a number that increments. What is MySQL Binary Log? How do I stop these files being created?
[click to continue…]

I'm setting up WordPress based blog system under Debian or Ubuntu Linux. I am getting an error which read as follows:

Your PHP installation appears to be missing the MySQL extension which is required by WordPress

How do I fix this problem under Debian or Ubuntu Linux?
[click to continue…]

MySQL List Databases

Q. How do I display a list of all databases under MySQL Server?
[click to continue…]

How To Start and Stop MySQL Database Server From A Shell Prompt

Q. How do I start and stop mysql server under Debian / Ubuntu Linux system?

[click to continue…]