I got the Java connection through the jdbc driver, so mysql is talking to Java finally
1) "jdbc:mysql://localhost:3306/mysql" on my comp
2) root
3) passwd of the mysql root user
I can deal with...
Type: Posts; User: willemjar
I got the Java connection through the jdbc driver, so mysql is talking to Java finally
1) "jdbc:mysql://localhost:3306/mysql" on my comp
2) root
3) passwd of the mysql root user
I can deal with...
when feeding for:
1) "MySQL:jdbc:mysql://localhost:3306/"
2) root
3) the root password (of mysql root of course) I get:
29-ago-2013 15:31:26 learningdatabase.connectToAndQueryDatabase main...
====================
the three arguments of getConnection are they:
1) path to the jdbc driver (have the driver but can not find it)
2) username = mysql or a to be created usergroup for mysql...
So through the command line I started mysql and I can get into mysql using my password (by owning to command line root)!
-I created a test database called: bookstore;
-created a table called:...
Here is some basic info of getting started with mysql on comment line.
Next I will see how this stuff connects with java, right?
Reseting root password MySQL
(file location on my comp: ls...
Things are starting to work out, I did create my DB "realestate"
and thinking about its design and found this for real dummies like me:
A Simple Guide to Database Design in MySQL - LINUX For You
...
thanks, I'll go into some reading first
For the moment I stopped the server like this:
sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
and got:
Password:
Stopping MySQL database server
iMac:mysql willem$
So I am safe for the...
But there is more trouble, what about this:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Mann this is not easy, I got so far now:
willem$ /usr/local/mysql/bin/mysqld_safe --skip-grant-tables
130821 09:30:17 mysqld_safe Logging to '/usr/local/mysql/data/iMac.local.err'.
touch:...
"Get familiar with the database. Use the command line to connect to the database, create users, create tables, and learn about database normalization, keys, indexes, and referential integrity...
Don't worry I'll find it but it is like a whole new subject this mysql
It is overwhelming and try to understand where to start!
First there is the installing issue with many, many command line --I...
Syedhal, where at the command line?
these are my mysql helps....
mysql> help
For information about MySQL products and services, visit:
MySQL :: The world's most popular open source...
I am following instructions:
-If you are using Netbeans IDE, than you have already the driver at hand. Inside the Projects tab, right click on the Libraries node and select Add Library option. From...
So beginning to study database stuff.
I installed MySQL (32bits) on my Imac (OSX 10.6.8).
The status panel says "running"
So what should I be doing next?
I work from a Netbean java...