Linux mysql命令安装允许远程连接的安装设置思路方法

而这些东西正是新手很困惑地方下是我安装笔记在Centos虚拟机上安装成功中文参考:http://xieyu.blog.51cto.com/213338/59749英文参考 How to Install MySQL 5.0 _disibledevent=>
[client] + default-character-=utf8 [mysqld] + default-character-=utf8 [mysql] + default-character-=utf8

apache安装请先进入/home/tmp目录(cd /home/tmp) tar -zxvf httpd-2.2.13.tar.gz cd httpd-2.2.13./configure --prefix=/usr/local/apache2 --enable-so --enable-rewrite --enable-auth-digest=shared --enable-ssl --enable-deflate make history make cp /usr/local/apache2/bin/apachectl /etc/init.d chmod 755 /etc/init.d/apachectl /usr/local/apache2/bin/apachectl start php安装 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-mb \ --enable-zend-multi \ --enable-s \ --enable-soap \ --enable-zip
Linux mysql

make 修改apache httpd.conf(apache/conf/httpd.conf)添加如下部分:LoadModule php5_module modules/libphp5.so AddType 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 附:Linux mysql 允许远程连接

/usr/local/mysql/bin/mysql -u root -p (进入mysql) use mysql; SELECT `Host`,`User` FROM user; UPDATE user SET `Host` = '%' WHERE `User` = 'root' LIMIT 1; flush privileges; 注意在mysql 命令行形式下定要输入";". v经过configure就可以make了
Linux mysql
make 注意pdo_mysql全路径我是:
/usr/local/php/lib/php/extensions/debug-non-zts-20060613/pdo_mysql.so
然后在/usr/local/lib/php.ini
加上句:
extension=/usr/local/php/lib/php/extensions/debug-non-zts-20060613/pdo_mysql.so
重新启动apache即可看到已经加载pdo_mysql成功



在ubuntu7.10中mysql安装,默认是只能本机访问需要打开用户权限和mysql本机绑定
1、在命令行底下打开用户权限:grant all privileges _disibledevent=>将”bind-address = 127.0.0.1“注释
sudo /etc/init.d/mysql restart重启即可远程访问

延伸阅读