1. mysql -udev -pxxxxxxx // remarks :-u user name -p password 
2. show databases; // See what databases are
3. use datebase; // Which databases to use
4. show tables; // See which tables are available
5. exit; // sign out mysql
6. desc table; // View table structure

linux Next to the database operation of more related articles

  1. linux Next mysql Operation of database

    This paper mainly aims at linux Next mysql Database installation , As well as the database creation and the simple database operation carries on the explanation . ①.Mysql Database installation : Database installation is divided into source code installation and rpm install . Of course, for the veteran, you need to customize ...

  2. Linux Graphical tool of down link database

    ( One ).Linux In the environment mysql Installation .SQL operation Linux Lower installation MySQL (rmp --help) Basic steps : Upload software -> Check current Linux Is the environment installed , If you find that the system comes with , To uninstall first -& ...

  3. linux Under the shell operation mysql

    (1)MySQL Start of After a server restart , Use > mysql -u root -p Login is the following error : ERROR 2002 (HY000): Can't connect to local ...

  4. Linux Next MySQL Database master-slave synchronization configuration

    explain : operating system :CentOS 5.x 64 position MySQL Database version :mysql-5.5.35 MySQL master server :192.168.21.128 MySQL From the server :192.168.21.129 Get ready ...

  5. Linux Next mysql The relevant operation

    Linux Next mysql The relevant operation 1. establish MySQL mysql -u root -p create user 'username'@'%' identified by 'password'; % You can choose ...

  6. Linux Next MySQL Backup and recovery of database

    Linux Next MySQL Backup and recovery of database author :Grey Original address : Github Language sparrow Blog Garden Based on version MySQL5.7 Deepin Linux 15.11 xtrabackup-2.4.18 ...

  7. linux Next oracle Database character set modification

    linux Next oracle Database character set modification 0.RHEL6.7.oracle11gr2 1. Sign in oracle. In the installation oracle The user enters the database . $ sqlplus / as sysdba 2. Inquire about ...

  8. linux Text operation under Text search ——grep

    Abstract : Do you have such an application scenario : Debug a program , appear debug A reminder of , Now you need to locate which file contains this debug Information , in other words , You need multiple files in one directory ( May contain subdirectories ) Find the location of a string in : ...

  9. linux Pass through sysfs operation GPIO

    linux Pass through sysfs operation GPIO In embedded devices, it is necessary to GPIO The operation of is the most basic operation . The general approach is to write a separate driver , Most of the examples on the Internet are like this . Actually linux There is a general GPIO Operation interface , That's it ...

Random recommendation

  1. yum Installation configuration

    1. Delete redhat The original yum rpm -aq|grep yum|xargs rpm -e --nodeps 2. download yum The installation files http://mirrors.163.com/centos/6/ ...

  2. Android Environment building

    One .Android Environment building development tool : Android Studio( development tool , The premise is to install first java JDK) Download address :http://www.androiddevtools.cn/   Oracl ...

  3. *MyBatis frame Print on console sql sentence

    stay log4j.properties  Just add this code in #log4j.rootLogger=INFO, Console#Consolelog4j.appender.Console=org.a ...

  4. STM32 Of 12864 LCD serial control

    Find out 12864 Only when the main function is continuously refreshed can the data be displayed ,, The reason is that there is no delay in write instruction and write data , Just add a delay .

  5. HTML Static web page Window.document object

    One . Element found : docunment.getElementById("id"): according to id look for , One at most :    var a =docunment.getElementById(&qu ...

  6. Fast CGI working principle

    http://www.cppblog.com/woaidongmao/archive/2011/06/21/149092.html One .FastCGI What is it? ? FastCGI It's not about language . Scalable architecture ...

  7. js And checkbox Select all codes for / Totally unselected , Use id Get elements , instead of name

    Whenever there are multiple options , There's always an idea that : Future generations , Totally unselected , If any of the sub options are selected , The parent option also has to be selected . Be careful : This is based on id To get the elements , But it can't be used directly getElementById, Because that only returns one , It's not a collection . ...

  8. linux Use your own mail Send E-mail ( Super simple )

    linux The easiest way to email , You can also use the company email , Need to install mailx Tools ,mailx Is a small mail delivery program . The specific steps are as follows : 1. install [root@001 ~]# yum install mai ...

  9. [ Re posting ]Centos7 yum install Chrome browser

    Centos7 yum install Chrome browser https://www.cnblogs.com/ianduin/p/8727333.html as well as https://blog.csdn.net/libaine ...

  10. js Array operation

    js Array operation use js It's been a long time , But they didn't go into it js The array form of . It's easy to use it once in a while string.split(char). A project I did during this period , There are many uses for arrays , To think oneself js The master himself has no way to start , One ...