how to create mysql database in ubuntu from command line
how to create mysql database in ubuntu from command line
Want to know how to create mysql database in ubuntu from command line? we have a huge selection of how to create mysql database in ubuntu from command line 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,
This article mainly summarizes the installation of MySQL + problem handling + security optimization on Ubuntu, which is very detailed and comprehensive. if you need it, you can refer
0. description
Of course, MySQL is installed in a variety of ways.
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
0. of course, there are a variety of MySQL installation methods. on Ubuntu, you can use apt-get to install MySQL. the advantage is that it is fast and convenient. Basically, it will help you solve the dependency problem of all function libraries.
.....Today, tossing the time of the afternoon, the recovery of countless virtual machine snapshots, finally on Ubuntu installed MySQL.MySQL is downloaded from the official website: Mysql-server_5.7.16-1ubuntu12.04_i386.deb-bundle.tarThe system is 32-
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
0. Notes
Of course, MySQL is installed in a variety of ways, in Ubuntu, you can use the Apt-get way to install, the advantage is: fast and convenient. Basically, it will help you solve all the function library dependencies, normally, as long as apt-
1. Download the MySQL Installation FileThe following two files are required to install MYSQL:MySQL-server-4.0.23-0.i386.rpmMySQL-client-4.0.23-0.i386.rpmTo: http://www.mysql.com/downloads/mysql-4.0.html, open this webpage and pull down the webpage
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 (
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.