MySQL command installation allows remote connections

Linux mysqlapache PHP installation process. Copy Apache, MySQL, php tar.gz files to the/home/tmp directory. Then execute the following command

Linux MySQL Installation

cd/home/tmp groupadd mysql mysql useradd-g mysql tar-zxvf mysql-5.1.33.tar.gz cd mysql-5.1.33./configure--prefix=/usr /local/mysql make make install cd/usr/local/mysql chown-r root. Bin/mysql-u root-p chgrp-r MySQL. (Note that there is a.) Cd/home/tmp CD mysql-5.1.33 ln-s/usr/local/mysql//usr/local/mysql CP support-files/my-small.cnf/etc/my.cnf modified MY.CNF [Sqld] Add user=mysql below. Chown root/etc/my.cnf chgrp root/ect/my.cnf chmod 644/etc/my.cnf/usr/local/mysql/bin/mysqld_safe--user=mysql & CP Support-files/mysql.server/etc/init.d/mysql chmod 755/etc/init.d/mysql chkconfig--add mysql chkconfig--level on/usr/local/mysql/bin/mysql_install_db--user=mysql/usr/local/mysql/bin/mysql-u Root (if you can enter the MySQL command line, the MySQL configuration is successful.) )

Edit/etc/my.cnf

[Client] + Default-character-set=utf8 [mysqld] + default-character-set=utf8 [MySQL] + Default-character-set=utf8

Apache installation, please go to the/home/tmp directory (cd/home/tmp) tar-zxvf httpd-2.2.13.tar.gz CD httpd-2.2.13./configure Apache2--enable-so--enable-rewrite--enable-auth-digest=shared--enable-ssl--enable-deflate make history Install CP/USR/LOCAL/APACHE2/BIN/APACHECTL/ETC/INIT.D chmod 755/etc/init.d/apachectl/usr/local/apache2/bin/ Apachectl start PHP installation cd/home/tmp tar-xzf php-5.3.0.tar.gz CD php-5.3.0

./configure--prefix=/usr/local/php--with-apxs2=/usr/local/apache2/bin/apxs--with-mysql=/usr/local/mysql-- With-pdo-mysql--with-zlib--with-libxml-dir--with-xsl--enable-mbstring--enable-zend-multibyte-- Enable-soap--enable-zip

Linux MySQL

Make install modifies the Apache httpd.conf (apache/conf/httpd.conf) to add the following: LoadModule php5_module modules/libphp5.so application/x-httpd-php. php

CP Php.ini-development/usr/local/php/lib/php.ini/usr/local/apache2/bin/apachectl start/usr/local/apache2/bin/ Apachectl Stop/usr/local/apache2/bin/apachectl Start

Enclosure: Linux mysql allows remote connection

/usr/local/mysql/bin/mysql-u root-p (enter MySQL) use MySQL; SELECT ' Host ', ' user ' from user; UPDATE user SET ' Host ' = '% ' WHERE ' user ' = ' root ' LIMIT 1; Flush privileges; Note that you must enter ";" under the MySQL command line form.

V after configure, you can make it.

Linux MySQL

Make install note the full path of the Pdo_mysql, and mine is:

/usr/local/php/lib/php/extensions/debug-non-zts-20060613/pdo_mysql.so

And then in/usr/local/lib/php.ini

Add a sentence:

Extension=/usr/local/php/lib/php/extensions/debug-non-zts-20060613/pdo_mysql.so

Restart Apache to see that the Pdo_mysql has been loaded successfully.

MySQL installation in ubuntu7.10, the default is only local access, you need to open user rights and MySQL native binding

1, open the user right under the command line: Grant all privileges on drupal.* to user@192.168.1.80 identified by ' User-password ';

In the Administrator interface, you can add access rights through the user admin Add Host->any host (the root user can only access this computer by default, and the newly added user can be remote)

2. Cancel MySQL Native binding:

Edit/ETC/MYSQL/MY.CNF

# Instead of skip-networking The default is now to listen only

# localhost which are more compatible and are not less secure.

Bind-address = 127.0.0.1

Add the "bind-address = 127.0.0.1" annotation

Sudo/etc/init.d/mysql Restart restart for remote access