Jump to Navigation

configutation

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

PHP:

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 '192.168.1.100'

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.

CREATE THE 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
system.

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

drupal:

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.

Linux:
Subscribe to RSS - configutation


Main menu 2

by Dr. Radut