CentOS 6.5 搭建phpMyAdmin管理平台_MySQL
CentOSphpmyadmin
实验需求:在服务器本机搭建mysql图形管理工具
Linux系统:CentOS6.5
1.简单部署LAMP平台
# yum -y install httpd mysql mysql-server php php-mysql php-pdo
# rpm -ivh php-mbstring-5.3.3-26.el6.x86_64.rpm //此包安装光盘没有,需自己下载
2.修改httpd配置文件,启动服务
# vim /etc/httpd/conf/httpd.conf
……
ServerName localhost.localdomain
……
DirectoryIndex index.php index.html
……
# service httpd start
3.安装phpMyAdmin软件包
# unzip phpMyAdmin-4.1.2-all-languages.zip -d /var/www/html/ //解压到网站目录
# cd /var/www/html/
# mv phpMyAdmin-4.1.2-all-languages/ phpmyadmin //改名方便登录
# cd phpmyadmin/
# cp config.sample.inc.php config.inc.php //建立主配置文件
# vim config.inc.php
……
17 $cfg['blowfish_secret'] = 'jin123'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ //随便写几个字符
……
31 $cfg['Servers'][$i]['host'] = '192.168.100.1'; //本机IP
#若phpMyAdmin软件不是安装在mysql服务器本机上,则可填写客户端IP,但需在服务器上先授权客户端有登录mysql服务的权限
4.启动服务
# service mysqld start
# service httpd restart
5.浏览器登录
http://192.168.100.1/phpmyadmin

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



The main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.

Although Notepad cannot run Java code directly, it can be achieved by using other tools: using the command line compiler (javac) to generate a bytecode file (filename.class). Use the Java interpreter (java) to interpret bytecode, execute the code, and output the result.

The main uses of Linux include: 1. Server operating system, 2. Embedded system, 3. Desktop operating system, 4. Development and testing environment. Linux excels in these areas, providing stability, security and efficient development tools.

To view the Git repository address, perform the following steps: 1. Open the command line and navigate to the repository directory; 2. Run the "git remote -v" command; 3. View the repository name in the output and its corresponding address.

I encountered a tricky problem when developing a small application: the need to quickly integrate a lightweight database operation library. After trying multiple libraries, I found that they either have too much functionality or are not very compatible. Eventually, I found minii/db, a simplified version based on Yii2 that solved my problem perfectly.

Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.

To set the shortcut keys for Sublime Text, follow these steps: Open the shortcut key settings file Key Bindings - User. Add shortcut key settings using the format { "keys": ["key combination"], "command": "command" }. Save changes. Reload the shortcut key settings for the changes to take effect.

There are many ways to customize a development environment, but the global Git configuration file is one that is most likely to be used for custom settings such as usernames, emails, preferred text editors, and remote branches. Here are the key things you need to know about global Git configuration files.
