how to use phpMyAdmin

phpMyAdmin 是一个用PHP编写的,可以通过 web方式控制  phpMyAdmin和操作 MySQL数据库。通过 phpMyAdmin 可以完全对数据库进行操作,例如建立、复制、删除数据等等。如果使用合适的工具,MySQL 数据库的管理就会变得相当简单。应用 MySQL 命令行方式需要对 MySQL 知识非常熟悉,对 SQL语言也是同样的道理。不仅如此,如果数据库的访问量很大,列表中数据的读取就会相当困难。

当前出现很多 GUI MySQL客户程序,其中最为出色的是基于 Web 的 phpMyAdmin 工具。这是一种 MySQL 数据库前台的基于PHP的工具。

php环境搭建!

1. 到phpmyadmin官方网站下载phpmyadmin,下载地址:http://www.phpmyadmin.net/home_page/downloads.php

2. 将phpmyadmin目录拷贝到web目录下,如果使用的apache 目录为:Apache/htdocs

3. 输入: http://域名/phpadmin/index.php 访问, 若成功安装phpmyadmin则显示如下界面:

输入您的数据库用户名和密码,通常用户名为root,密码为你的安装mysql时自己设置的密码
成功登陆后进到如下界面:

Came cross some problems:

Extension mysqli is missing, phpmyadmin doesn’t work

ubuntu 12.04. installed apache2, php5, mysql and phpmyadmin, In the php.ini file, I uncommented extension=mysql.so line, but doesn’t work:

The mysqli extension is missing. Please check your PHP configuration. <a href=”Documentation.html#faqmysql” target=”documentation”><img src=”./themes/pmahomme/img/b_help.png” width=”11″ height=”11″ alt=”Documentation” title=”Documentation” /></a>

Latest phpMyAdmin versions require mysqli extension and will no longer work with mysql one (note the extra “i” at the end of it’s name).

sudo apt-get install php5-mysql //Will install package containing both old one and the new one, so afterwards all you need to do is to add in /etc/php5/apache2/php.ini:

extension=mysqli.so //用/ 查找的时候,可以用n来继续查找下一个

You need to restart apache server before navigating to phpmyadmin page:

sudo /etc/init.d/apache2 restart

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

生活在西班牙

自己动手丰衣足食

BlueAsteroid

Just another WordPress.com site

Jing's Blog

Just another WordPress.com site

Start from here......

我的心情魔方

天才遠私廚

希望能做一個分享各種資訊的好地方

语义噪声

西瓜大丸子汤的博客

笑对人生,傲立寰宇

Just another WordPress.com site

Where On Earth Is Waldo?

A Project By Melanie Coles

the Serious Computer Vision Blog

A blog about computer vision and serious stuff

Cauthy's Blog

paper review...

Cornell Computer Vision Seminar Blog

Blog for CS 7670 - Special Topics in Computer Vision

datarazzi

Life through nerd-colored glasses

Luciana Haill

Brainwaves Augmenting Consciousness

槑烎

1,2,∞

Dr Paul Tennent

and the university of nottingham

turn off the lights, please

A bunch of random, thinned and stateless thoughts around the Web

%d bloggers like this: