1, very strange, install MySQL, actually start an error.
You can use it through the following:
Select the default directory when installing.
Right-click Remove Server, Install Server
strange!
2. Create a data sheet
Log in: CD to bin directory, enter mysql -u root
CREATE TABLE BOARD_DATA (NUM INT AUTO_INCREMENT PRIMARY KEY, SUBJECT CHAR (100) NOT NULL, CONTENT VARCHAR (255), WRITER_NAME CHAR (40) NOT NULL, WRITER_EMAIL CHAR (40), REG_DATE DATE, VIEWCOUNT INT, PASSWORD CHAR (10)) ;
3, Mysql and JBuilderx Database connection one first at http://www.mysql.com/downloads/download.php?file=downloads/connector-j/mysql-connector-java-2.0.14.zip Download mysql JDBC Drive. After download, decompress it. Two open JBuilder, select Tools-> Configure Libraries, then select New in the list of the left, fill in: name: mysql, location: user home, then click Add, add directory f: /mysql-connector-java-2.0 .14 / mysql-connector-java-2.0.14 / mysql-connectionor-java-2.0.14-bin.jar (after the path, the path in the form is the last file suffix is .jar), determine three, project-- > Prject Properties -> Paths-> Required libraries -> add Add to add User Home / MySQL OK 4, Tools-> Enterprise Setup -> Database Drivers--> Add, add user home / mysql, add After the list box is displayed, mysql.config, determine five, Tools-> Database pilot -> view -> options-> drivers--> add Driver Class: com.mysql.jdbc.driver SIMPLE URL: MySQL: // LocalHost: 3306 / mysql Once, Tools -> Database Pilot -> New Driver Select com.mysql.jdbc.driver Fill in URL: JDBC: MySQL: // Server IP Address Or host name: 3306 / mysql? User = root & password = ""
4. Import files
The following command: mysql -uroot -p
