• ADADADADAD

    mysql如何查看用户名[ mysql数据库 ]

    mysql数据库 时间:2024-12-03 10:27:30

    作者:文/会员上传

    简介:

    启动数据库:[root@server ~]# mysqld_safe &[1] 3289[root@server ~]# 130913 08:19:58 mysqld_safe Logging to '/usr/local/mysql/data/server.gao.err'.130913 08

    以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。

    启动数据库:

    [root@server ~]# mysqld_safe &[1] 3289[root@server ~]# 130913 08:19:58 mysqld_safe Logging to '/usr/local/mysql/data/server.gao.err'.130913 08:19:58 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

    连接到数据库:

    [root@server ~]# mysql -uroot -pEnter password: Welcome to the MySQL monitor.Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.6.13 MySQL Community Server (GPL)Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>

    查看数据库列表:

    mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql|| performance_schema || test |+--------------------+rows in set (0.00 sec)mysql>

    查看用户状态:

    mysql> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> select host,user from mysql.user;+------------+------+| host | user |+------------+------+| 127.0.0.1| root || ::1| root || localhost||| localhost| root || server.gao ||| server.gao | root |+------------+------+rows in set (0.00 sec)mysql>
    mysql如何查看用户名.docx

    将本文的Word文档下载到电脑

    推荐度:

    下载
    热门标签: mysql如何查看