mysql 环境搭建

平台： ubuntu10.10

1. 安装：mysql
   sudo apt-get install mysql-server
   在安装的过程中，会提示我们需要设置 mysql的密码，这个密码就是我们以后登陆mysql的密码了

2. 登陆 mysql
  

ywx@ywx:~/yu/mysql$ mysql -u root -p 登陆mysql
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 39
Server version: 5.1.49-1ubuntu8.1 (Ubuntu)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> exit  退出mysql
Bye
ywx@ywx:~/yu/mysql$

3. 还需要配置文件吗 ？？本地？？外机 ？？


4. 参看mysql 安装到哪里去了

ywx@ywx:~/yu/mysql$ dpkg -L mysql-
mysql-client-5.1       mysql-common           mysql-server-5.1
mysql-client-core-5.1  mysql-server           mysql-server-core-5.1
ywx@ywx:~/yu/mysql$ dpkg -L mysql-server
/.
/usr
/usr/share
/usr/share/doc
/usr/share/doc/mysql-server
/usr/share/doc/mysql-server/copyright
/usr/share/doc/mysql-server/changelog.Debian.gz
ywx@ywx:~/yu/mysql$

5. 参看 数据库文件放在哪里了

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test2              |
| test3              |
+--------------------+
4 rows in set (0.00 sec)

$sudo find / -name test3 > find.txt

放在这里

/var/lib/mysql/test3

参考资料：