LAMP,PHP环境筹建
LAMP,PHP环境搭建
用apt-get方法安装mysql5 + Apache2 + PHP5+Phpmyadmin:
大家请先看下Ubuntu的WIKI,(http://wiki.ubuntu.org)上面讲的很详细的。但本人按上面做的第一次没有成功。apache2,php5,mysql5都可以运行,就是phpmyadmin不能用。
本人得到的经验是:MYSQL安成功后,一定要先给它设个密码,这上步是不可少的。
此篇只代表个人的观点和经验,可能会片面化和有错误,请大家批评指正,有问题大家一起来讨论!!
1 .要用apt-get的方式安装,最好,也可能是必须先运行下面在命令升级自己的系统,我的就只能先升级后才能安装mysql5 + Apache2 + PHP5的。
我在没升级前运行sudo apt-get install apache2 php5 mysql-server 是没有用的。而如果你找的源不好或是你的网络不稳定的话,你也有可能升级不成。这样的话,你想用apt-get的方式来安装一些软件时可能是不能安装的。
sudo apt-get update
sudo apt-get dist-upgrade
2.安装:
sudo apt-get install mysql-server
安装上mysql5
sudo apt-get install apache2
安装apache2
sudo apt-get install php5
安装php5
sudo apt-get install php5-mysql
安装php的mysql模块
sudo apt-get install php5-gd
安装GD库
在运行上面的命令的时候,可以留心看下libapache2-mod-auth-mysql(安装apache2时可能会安上)和libapache2-mod-php5,如果看到安上了就不用再单独安装了。
3 . 配置:
我们刚安装上的MYSQL,只有一个系统默认的root用户,而且是没有密码的,此时我们一定要给MYSQL设置一个密码,个人认为一定要的。因为我第一次安装时就是没有搞这一步,认为和win下的一样,可先不用设置。可是当我在http://127.0.0.1/phpmyadmin下用root不带密码登陆时怎样也不会成功!
终端下输入:
mysql -u root
mysql> GRANT ALL PRIVILEGES ON *.* TO [email protected] IDENTIFIED BY "[email protected]";
[email protected],可以自由设置,但最好是设个安全点的。
mysql>\q 退出mysql
mysql的配置文件-my.cnf:(路径:/etc/mysql/my.cnf)
运行命令:sudo gedit /etc/mysql/my.cnf可编辑。
apache2的配置文件-apache2.conf(路径:/etc/apache2/apache2.conf)
运行命令:sudo gedit /etc/apache2.conf可编辑
PHP的配置文件-php.ini:(路径:/etc/php5/apache2/php.ini)
运行命令:sudo gedit /etc/php5/apache2/php.ini可编辑。
此时这三个文件暂时不用编辑,如为了安全起见和优化,是一定要编辑的。具体的大家可参观其它资料,此篇暂不多说!!
4 . 安装phpmyadmin
sudo apt-get install phpmyadmin
安装完毕可测试:http://127.0.0.1/phpmyadmin 当出来界面就行了,暂时先别登录,等改下你的PHPMYADMIN的配置文件(config.inc.php)再登陆。
终端输入:sudo gedit /etc/phpmyadmin/config.inc.php
找到$cfg['Servers'][$i]['password']= '';
改成:$cfg['Servers'][$i]['password']= [email protected]';
[email protected]
5 . 此时最好重新启动计算机,(在网看到有人这样说,因是第二次安装也就照做了)打开浏览器http://localhost/phpmyadmin/
用户名输入root,再输入刚改的密码,然后执行
可以看到在win下那可亲的phpmyadmin面貌了。
小结:
apache2的操作命令:
启动:sudo /etc/init.d/apache2 start
重启:sudo /etc/init.d/apache2 restart
关闭:sudo /etc/init.d/apache2 stop
apache2的默认主目录:/var/www/
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/13834/showart_493981.html

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics











In MySQL, the function of foreign keys is to establish the relationship between tables and ensure the consistency and integrity of the data. Foreign keys maintain the effectiveness of data through reference integrity checks and cascading operations. Pay attention to performance optimization and avoid common errors when using them.

The main difference between MySQL and MariaDB is performance, functionality and license: 1. MySQL is developed by Oracle, and MariaDB is its fork. 2. MariaDB may perform better in high load environments. 3.MariaDB provides more storage engines and functions. 4.MySQL adopts a dual license, and MariaDB is completely open source. The existing infrastructure, performance requirements, functional requirements and license costs should be taken into account when choosing.

NGINX and Apache each have their own advantages and disadvantages, and the choice should be based on specific needs. 1.NGINX is suitable for high concurrency scenarios because of its asynchronous non-blocking architecture. 2. Apache is suitable for low-concurrency scenarios that require complex configurations, because of its modular design.

Apache is an open source web server software that is widely used in website hosting. Installation steps: 1. Install using the command line on Ubuntu; 2. The configuration file is located in /etc/apache2/apache2.conf or /etc/httpd/conf/httpd.conf. Through module extensions, Apache supports static and dynamic content hosting, optimizes performance and security.

AI can help optimize the use of Composer. Specific methods include: 1. Dependency management optimization: AI analyzes dependencies, recommends the best version combination, and reduces conflicts. 2. Automated code generation: AI generates composer.json files that conform to best practices. 3. Improve code quality: AI detects potential problems, provides optimization suggestions, and improves code quality. These methods are implemented through machine learning and natural language processing technologies to help developers improve efficiency and code quality.

MySQL and phpMyAdmin can be effectively managed through the following steps: 1. Create and delete database: Just click in phpMyAdmin to complete. 2. Manage tables: You can create tables, modify structures, and add indexes. 3. Data operation: Supports inserting, updating, deleting data and executing SQL queries. 4. Import and export data: Supports SQL, CSV, XML and other formats. 5. Optimization and monitoring: Use the OPTIMIZETABLE command to optimize tables and use query analyzers and monitoring tools to solve performance problems.

To safely and thoroughly uninstall MySQL and clean all residual files, follow the following steps: 1. Stop MySQL service; 2. Uninstall MySQL packages; 3. Clean configuration files and data directories; 4. Verify that the uninstallation is thorough.

Efficient methods for batch inserting data in MySQL include: 1. Using INSERTINTO...VALUES syntax, 2. Using LOADDATAINFILE command, 3. Using transaction processing, 4. Adjust batch size, 5. Disable indexing, 6. Using INSERTIGNORE or INSERT...ONDUPLICATEKEYUPDATE, these methods can significantly improve database operation efficiency.
