MySQL command to show list of databases on server
来源:互联网 发布:恶搞配音软件 编辑:程序博客网 时间:2024/05/17 22:55
Q. I am new to MySQL database server. How do I show the list of databases on my server? Is there any good GUI frontend exists for the same?
A. You can use mysql command to connect to mysql server and list available databases.
Task: Mysql list databases
mysql is a simple command-line tool. mysql is command line and it is very easy to use. Invoke it from the prompt of your command interpreter as follows:$ mysql
Output:
mysql>
You may need to provide mysql username, password and hostname, use:$ mysql --user=your-user-name --password=your-password
mysql>
To list database type the following command
mysql> show databases;
Output:
+--------------------+| Database |+--------------------+| information_schema || mysql |+--------------------+2 rows in set (0.00 sec)
information_schema and mysql are name of databases. To use these database and to list available tables type the following two commands:mysql> use mysql;
Output:
Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changed
Now list tables:mysql> show tables;
Output:
+---------------------------+| Tables_in_mysql |+---------------------------+| columns_priv || db || func || help_category || help_keyword || help_relation || help_topic || host || proc || procs_priv || tables_priv || time_zone || time_zone_leap_second || time_zone_name || time_zone_transition || time_zone_transition_type || user |+---------------------------+17 rows in set (0.00 sec)mysql>
- MySQL command to show list of databases on server
- Connecting to databases like Mysql, SQL Server or Oracle on J2ME devices
- LIST OF NOSQL DATABASES
- Failed to list databases
- mysql show databases 看不到mysql数据库
- mysql 新建用户不能show databases;
- mysql为用户赋予show databases权限
- 【MySQL】 命令行下执行show databases
- Mysql命令show databases:显示所有数据库
- MySQL命令show databases:显示所有数据库
- Show databases
- show databases
- MySQL权限篇之SHOW DATABASES及SHOW VIEW
- sqoop连接mysql出现Failed to list databases com.mysql.jdbc.exceptions.jdbc4.CommunicationsException
- spark thrift server kerberos 配置下show databases 报错
- Oracle中和MYSQL show create table tablename,desc tablename,show tables, show databases 相似效果。
- list of vim command
- mysql控制台 show databases不显示结果的原因
- 使用RegexKitLite使iphone也可以使用正则表达式
- 问题汇总
- 解决Tomcat.exe或者startup.bat 一闪无法打开的问题
- Perl文件系统
- 详解 Qt 中各种丰富容器类
- MySQL command to show list of databases on server
- Date的处理
- python调用短信猫控件,发短信
- 网站优化案例策划分享
- $(if $(KBUILD_VERBOSE:1=),@) 语法释疑
- 关于C语言中类似"a<b<c"条件的值
- ubuntu 下不能识别 eth0 解决方法
- flex 如何设置蒙版(遮罩)
- 五步搞定sql server2005数据库日志清除