Learn about import mysql database command line ubuntu, we have the largest and most updated import mysql database command line ubuntu information on alibabacloud.com
This article mainly introduces someMySQL databaseOfCommand LineSome Common commands, including starting and stopping services, user logon, user management, and use of commonly used batch processing commands. Let's take a look at them.
Start and Stop
MySql: www.mysql.org
First, start and stop the mysql Service
Net stop mysql
Net start mysql
Second, log on to mysql
Mysql-u user name-p User Password
Mysql-uroot-p. After you press enter, you are prompted to enter the password, enter 12345,
Ubuntu 7.04 build Ubuntu JSP Platform development environment mysql+tomcat+apache+j2sdk1.6 enter RPM-Q-A in terminal before all installation starts to see if the RPM is installed and RPM Package Required Software if no RPM is installed, enter sudo
From: http://www.linuxidc.com/Linux/2011-01/31263.htm
I. Prepare the development environment1. install linux first. Ubuntu is used here.10.102. Install the MySQL software package. MySQL 10.10 is included in the system repository:Sudo apt-Get
The example of this article summarizes the various operation commands used by MySQL. Share to everyone for your reference, specific as follows:
MySQL installation directory
Database directory
/var/lib/mysql/
Configuration file
/usr/share/mysql (
When using MySQL DATA, you will always encounter Import and Export situations. Therefore, it is very important to correctly import and export data! The following method is used in the work:
When using MySQL DATA, you will always encounter Import and
MySQL Database Import and Export
When using MySQL DATA, you will always encounter Import and Export situations. Therefore, it is very important to correctly import and export data! The following method is used in the work:
Import:
Import data
Share Mysql commands,
1. Connect to Mysql
Format: mysql-h host address-u user name-p User Password
1. Connect to MYSQL on the local machine.
First, open the DOS window, enter the mysql \ bin directory, type the mysql-u root-p command, and press
Ubuntu 9.04InstallMysql Proxy LuaIs the content to be introduced in this article, mainly to understandMysql ProxyInUbuntu 9.04The installation environment under and has passed the test. For details, see this article.
Install mysql
1,
MySQL installation directoryDatabase directory:/var/lib/mysql/Configuration file:/usr/share/mysql (mysql.server command and configuration file)Related commands:/usr/bin (mysqladmin mysqldump, etc. order)Startup script:/etc/init.d/mysql (Directory of
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.