I wasn't really sure where to put this, but i will stick with here for now.
I have installed mySQL onto my mac and i want to create some java programs which will connect to it, i have yet to create the database so when i try and connect i get an error message saying Unknown database 'databaseName'.
Could anyone tell me how to access mySQL to create this new database via the terminal? I have searched and nothing so far seems very clear. Alternatively is there any programs that would help manage the databases? i have used phpMyAdmin online but not locally. I assume all i need to do for this small problem is access via terminal and create the database though?
One option is to use the command line tool to connect to MySQL -- which for MySQL, I think it is simply "mysql". From there you can just do a "create database" command to create the database, followed by "create tables", unless of course, you want your application to do that.
Not sure about mac's but for windows MySql comes with a command line program called MySQL.exe which allows you to execute SQL statements.
If you want a GUI based tool try MySQL Workbench which I believe is available for the Mac.