Mac JDBC Connection MySQL

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