安装MySQL
返回
- 当前Mysql的版本和windows7的应用情况
- 已安装的Mysql的设定情况
可利用The Configuration Wizard进行设定(但是对现有的设定覆盖!)
必须暂时把病毒防护软件解除。
システムのプロバティ=>環境変数(N)=>システム環境変数(S)=>Pathを追加
C:\Program Files\MySQL\MySQL Server 5.0\bin
<![CDATA[
InnoDB Tablespace Settings
C:\Data\
Best Support For Multilingualism
c:\mysql>mysql -h localhost -p -u root
Enter password: ********
mysql> CREATE DATABASE cookbook;
Query OK, 1 row affected (0.02 sec)
mysql> CREATE DATABASE cookbook;
Query OK, 1 row affected (0.02 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cookbook |
| mysql |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> GRANT ALL ON cookbook.* TO 'cbuser'@'localhost' IDENTIFIED BY 'cbpass';
Query OK, 0 rows affected (0.11 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.11 sec)
c:\mysql>mysql cookbook -u cbuser -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
mysql>
]]>
返回