1. Download the JDBC Driver:
http://dev.mysql.com/downloads/connector/j/
2. Add the JDBC jar package to the project's Libs folder and build path
2. Change environment variables: Export Path=/usr/local/mysql/bin/:${path}
3. Default [email protected] no password
4. Change Password:
Command line: mysqladmin-u root-p password root
Commands in the MySQL environment:
mysql> UPDATE mysql.user SET password=password (' New password ') WHERE user= ' root ';
mysql> FLUSH privileges;
5. Restart MySQL
/library/startupitems/mysqlcom/mysqlcom restart
Stop MySQL
/library/startupitems/mysqlcom/mysqlcom stop
6. Enter Test
Mysql-u Root-proot
Use test
7. Create a new frequently
CREATE TABLE table1 (username varchar (primary) Key,password integer);
8 Inserting test data
INSERT INTO table1 values (' YYZ ', 123456);
INSERT INTO table1 values (' pengkv ', 123456);
INSERT INTO table1 values (' YJJ ', 123456);
INSERT INTO table1 values (' PJ ', 123456);
INSERT INTO table1 values (' cl ', 123456);
9. Writing code
Mac JDBC Connection MySQL