我的测试机上没有设root密码,设置下(内网机器,出不了外网,所以也没去动)。
设置root密码的命令为
set password for ‘root’@’localhost’=password(‘你的密码’);
root@debian:~# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.0.32-Debian_7etch6-log Debian etch distribution
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> set password for ‘root’@’localhost’=password(‘123456’);
Query OK, 0 rows affected (0.22 sec)
创建数据库 名字为man.
mysql> create database man;
Query OK, 1 row affected (0.07 sec)
使用man这个数据库.
mysql> use man;
Database changed
创建数据库的表
mysql> create table man (
-> id int unique not null,
-> name varchar(40),
-> age varchar(50),
-> primary key(id)
-> );
Query OK, 0 rows affected (0.00 sec)
增加表单内容
mysql> INSERT INTO man VALUES(1,'Brian','28'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO man VALUES(2,'Billy','26'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO man VALUES(3,'Dimitri','26'); Query OK, 1 row affected (0.01 sec) mysql> INSERT INTO man VALUES(4,'ross','30'); Query OK, 1 row affected (0.00 sec)
定义出这么个表格,ID,姓名,年龄。
mysql> select * from man; +----+---------+------+ | id | name | age | +----+---------+------+ | 1 | Brian | 28 | | 2 | Billy | 26 | | 3 | Dimitri | 26 | | 4 | ross | 30 | +----+---------+------+ 4 rows in set (0.00 sec)
mysql学习中…
昨天在本地安装了一些wp,呵呵,用的是哪个集成包。
回复:哦哦,集成的会方便些的~
呵呵,我现在也正在学习php呢,正好也在贵地瞅瞅了,看书眼睛受不了~~
回复:星座你抬举我了,我也是新手在学习的..一起进步~
呵呵,博主紧张了啊,貌似写错位了,创建和使用数据库那好像大意了吧~~~
回复:改过来啦,谢谢提醒哦!
看到内网就让我想起了公共安全专家局了。。。哎!
回复:看来longlan也是专家..