Jump to Navigation


203 - Change the MySQL's DATADIR

The default MySQL's datadir is placed in the /var/lib/mysql.
if you plan on using MySQL tables to store a lot of data and your /var partition might be a small space, it causes a space problem.
You had better move the MySQL's datadir to another space.

1. Stop your mysql server

# service mysqld stop  (or /etc/init.d/mysqld stop)

2. Create the new directories

3. chown the directory to the mysql:mysql user

177 - ERROR 1045 (28000) MySQL

If you got the following error, you need to reset the password.

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)


120 - To install PHP 5.2.x & MySQL 5.1.x in CentOS 5.x

phpMyAdmin v3.x needs to have PHP 5.2 and later version. But CentOS 5.x has still PHP 5.1.x.
This is one of methods on PHP & MySQL upgrade processes for CentOS 5.x.

1. Check your software versions in terms of PHP & MySQL

# php -v
# yum list installed php*

# mysql -V
# yum list installed mysql*

2. Install third party repository


117 - Error 2003 (HY000): Can't connect to MySQL server on ...

If you have a message like :

$ mysql -u root -p<password> -h myserver

ERROR 2003 (HY000): Can't connect to MySQL server on 'myserver' (10061)

* Port check from the remote machine.

# nmap -sS -O -p 3306 ''

If it opens the port, you get the message :

083 - MySQL Error 1130 "Host is not allowed to connect ...

Error 1130 is a networking error. The server cannot resolve the hostname of the client. Or the host is not allowed to connect to the MySQL server.

First you should check a user in the remort server in order to login, If not there, You have to create a user for remote login.

mysql> use mysql;
mysql> select host, user from user;

There is no your host name, the following command can create user.

058 - Create MySQL Database for Drupal

To install drupal application, you have to create MySQL Database.


This step is only necessary if you don't already have a database set-up (e.g. by
your host). In the following examples, 'username' is an example MySQL user which
has the CREATE and GRANT privileges. Use the appropriate user name for your

First, you must create a new database for your Drupal site (here, 'databasename'
is the name of the new database):


041 - How to install MySQL on ubuntu/debian

Before installation, make sure your package management tools are up-to-date. Also make sure you install all
the latest software available.

# sudo apt-get update

# sudo apt-get dist-upgrade

After a few minutes (depending on the state of your system), you’re ready to install MySQL on ubuntu.

Subscribe to RSS - configutation

Main menu 2

by Dr. Radut