<![CDATA[张宴的博客]]> http://zyan.cc/index.php zh-cn http://zyan.cc/post/279/ <![CDATA[命令行方式管理MySQL数据库实例[原创]]]> 张宴 <net@s135.com> Mon, 06 Aug 2007 08:53:42 +0000 http://zyan.cc/post/279/ http://blog.zyan.cc]

　　我一直习惯用phpMyAdmin对MySQL数据库进行管理，曾修改了一个《可管理多台远程MySQL服务器的phpMyAdmin 2.10.2》。但有些机器上因为安全等因素，只设置了允许从本机访问自身的MySQL端口，而且没有安装Apache和PHP，因而不能使用phpMyAdmin。于是，我只好使用命令行方式来对MySQL数据库进行管理。为了方便以后从命令行操作数据库可以更方便（拷贝、粘贴），我写下了这篇文章。

一、从命令行登录MySQL数据库服务器
1、登录使用默认3306端口的MySQL
/usr/local/mysql/bin/mysql -u root -p

2、通过TCP连接管理不同端口的多个MySQL（注意：MySQL4.1以上版本才有此项功能）
/usr/local/mysql/bin/mysql -u root -p --protocol=tcp --host=localhost --port=3307

3、通过socket套接字管理不同端口的多个MySQL
/usr/local/mysql/bin/mysql -u root -p --socket=/tmp/mysql3307.sock

4、通过端口和IP管理不同端口的多个MySQL
/usr/local/mysql/bin/mysql -u root -p -P 3306 -h 127.0.0.1


二、数据库操作SQL语句
1、显示服务器上当前存在什么数据库
SHOW DATABASES;

2、创建名称为rewin的数据库
CREATE DATABASE rewin;

3、删除名称为rewin的数据库
DROP DATABASE rewin;

............

Tags - , , ]]> http://zyan.cc/post/279/#blogcomment223 <![CDATA[[评论] 命令行方式管理MySQL数据库实例[原创]]]> tianqingbo <user@domain.com> Mon, 06 Aug 2007 13:55:36 +0000 http://zyan.cc/post/279/#blogcomment223   张宴我还是有个问题要问你，装centos系统可不可以从硬盘直接安装啊，我从来没有用过Linux系统，那要是装了Linux系统装硬件设备驱动还是像windows一样吗？有说错的地方还请见谅啊！ ]]> http://zyan.cc/post/279/#blogcomment236 <![CDATA[[评论] 命令行方式管理MySQL数据库实例[原创]]]> tianqingbo <user@domain.com> Fri, 10 Aug 2007 05:05:48 +0000 http://zyan.cc/post/279/#blogcomment236 可以用grub for dos（http://download.gna.org/grub4dos/）从硬盘的CentOS Linux ISO文件安装。
没用过也可以用VMware虚拟机安装Linux。
能否把步骤说的清楚点啊！
我不是很懂
是不是先下载CentOS Linux ISO
然后在下载grub for dos
最后在提取硬盘里面的CentOS Linux ISO
进行安装吗？
还有你说到http://download.gna.org/grub4dos/下载
我不晓得下那一个文件，太多了 ]]> http://zyan.cc/post/279/#blogcomment239 <![CDATA[[评论] 命令行方式管理MySQL数据库实例[原创]]]> tianqingbo <user@domain.com> Sun, 12 Aug 2007 13:32:45 +0000 http://zyan.cc/post/279/#blogcomment239 http://zyan.cc/post/279/#blogcomment532 <![CDATA[[评论] 命令行方式管理MySQL数据库实例[原创]]]> vv <user@domain.com> Mon, 24 Dec 2007 05:59:15 +0000 http://zyan.cc/post/279/#blogcomment532 http://zyan.cc/post/279/#blogcomment3434 <![CDATA[[评论] 命令行方式管理MySQL数据库实例[原创]]]> leosion <user@domain.com> Mon, 08 Jun 2009 16:05:49 +0000 http://zyan.cc/post/279/#blogcomment3434 http://zyan.cc/post/279/#blogcomment5730 <![CDATA[[评论] 命令行方式管理MySQL数据库实例[原创]]]> zhi <user@domain.com> Thu, 22 Apr 2010 15:20:53 +0000 http://zyan.cc/post/279/#blogcomment5730 http://zyan.cc/post/279/#blogcomment6195 <![CDATA[[评论] 命令行方式管理MySQL数据库实例[原创]]]> abcc <user@domain.com> Sun, 20 Jun 2010 04:00:46 +0000 http://zyan.cc/post/279/#blogcomment6195 http://zyan.cc/post/279/#blogcomment14170 <![CDATA[[评论] 命令行方式管理MySQL数据库实例[原创]]]> louis vuitton uk <fsf@fdg.com> Wed, 23 Nov 2011 00:49:59 +0000 http://zyan.cc/post/279/#blogcomment14170 louis vuitton uk for sale belongs to the sounding just what are termed as Louis Vuitton vintage best sellers, many other products and services for the reason that range appearing companies.You will easily notice the unfold zippers of this coach outlet store online. That is the decoration. There are some inside pockets for you as well. They are easy to match your clothes and to carry.Let us inspire your inner beauty with fine christian louboutin sale. Purse the elegance in bridal wedding. Enjoy the fashion. ]]> http://zyan.cc/post/279/#blogcomment17330 <![CDATA[[评论] 命令行方式管理MySQL数据库实例[原创]]]> chanel uk <xiang1234xiangxiang@gmail.com> Fri, 13 Apr 2012 09:16:08 +0000 http://zyan.cc/post/279/#blogcomment17330 chanel uk
burberry uk
ralph lauren uk ]]> http://zyan.cc/post/279/#blogcomment17350 <![CDATA[[评论] 命令行方式管理MySQL数据库实例[原创]]]> chanel uk <xiang1234xiangxiang@gmail.com> Fri, 13 Apr 2012 09:21:46 +0000 http://zyan.cc/post/279/#blogcomment17350 christian louboutin
tiffanys
gucci uk
louis vuitton sac ]]> http://zyan.cc/post/279/#blogcomment18726 <![CDATA[[评论] 命令行方式管理MySQL数据库实例[原创]]]> coach factory outlet <fgf@hotmail.com> Thu, 17 May 2012 02:57:18 +0000 http://zyan.cc/post/279/#blogcomment18726 coach factory outlet continues to be the delicate craft of leather-based master is accountable for,Would you like to meet more friends, or go with the times? If yes, coach factory online is opening welcome doors to you.in the market you definitely can find various colorways that are designed in as well as the high quality that applied in. For most of you would like to come. So just come to our coach factory outlet online store to choose one. ]]> http://zyan.cc/post/279/#blogcomment18727 <![CDATA[[评论] 命令行方式管理MySQL数据库实例[原创]]]> louis vuitton sale <fgf@hotmail.com> Thu, 17 May 2012 02:57:26 +0000 http://zyan.cc/post/279/#blogcomment18727 louis vuitton sale is one kind of fashion accessory with high cost performance among the Louis Vuitton accessories.Offering quality LV products with favorable prices, louis vuitton outlet store is at your service. Hurry up, or you can not seize the chance.in fact, louis vuitton is one of the most famous fashion design master.he opened the fist suitcase shop called after his name. ]]> http://zyan.cc/post/279/#blogcomment18728 <![CDATA[[评论] 命令行方式管理MySQL数据库实例[原创]]]> coach outlet online <fgf@hotmail.com> Thu, 17 May 2012 02:57:39 +0000 http://zyan.cc/post/279/#blogcomment18728 coach outlet online through the advertisement when I was shopping. And now I often brow the webpage and buy Coach bags online.It is a symbol regarding position not to mention nature.Here I would like to launch a excellent bags pertaining to business men.Which may be coach outlet store.coach outlet has always been simple,durable style features to win consumers.The products are more flexible,with easy bleaching,wear characteristics,and simply use a damp cloth. ]]> http://zyan.cc/post/279/#blogcomment18729 <![CDATA[[评论] 命令行方式管理MySQL数据库实例[原创]]]> coach outlet, <fgf@hotmail.com> Thu, 17 May 2012 02:57:47 +0000 http://zyan.cc/post/279/#blogcomment18729 coach outlet provide coach bags which won't be deteriorated into its overall styles by any means. It will maintain its looks, colors, and uniqueness for long time.coach outlet store online has been voted by Hour Detroit magazine readers as the Best of Detroit in their 12th annual readers'poll.Lots of women like which usually amount normally include a coach outlet online ,it provides coziness to many girls that don't even think it is a great bushel of great interest directly to them. ]]> http://zyan.cc/post/279/#blogcomment19878 <![CDATA[[评论] 命令行方式管理MySQL数据库实例[原创]]]> xujie777 <user@domain.com> Fri, 18 May 2012 07:54:28 +0000 http://zyan.cc/post/279/#blogcomment19878 louis vuitton uk, fashion Women's cheap Louis Vuitton bags in our store at affordable price.Thinking of interesting ways to cost a milestone birthday? louis vuitton online shop had one of the most distinctive distinctive celebrations.bakery along with living room operated by means of about three moment louis vuitton online Most effective Pastry Chef’s of the year Rammy Nominee Chef’s. ]]>