Assuming your logged into MySQL ok, does the user your using have permission to run CREATE TABLE queries?
I don't know... I just know I can't even grant permission if I can't create a database.
SpacePhoenix, you would think I am logged in properly if I can go directly to the bin and fire up mysql,exe immediately after install. Here is the mysql prompt and everything that say you are log-on, right ... or is there more? :
Welcome to the MySQL monitor. Commands end with ; or \\g.
Your MySQL connection id is 24
Server version: 5.5.17 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.
mysql> CREATE DATABASE please;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'please'
I'm talking command-line only ...
Here is something I tried with WorkBench: at "Open connection to start Querying" I can go in and create a new_schema, which is some kind of database that I read you can not perform transactions and it don't even show up on the command-line with show databases. Now I learn you can't even change the name of test database to something you want. Even the author don't provide any information of how to do any of this.
But I'm sure someone out of the millions of users someone figure out how to work at the command-line. I hope this gives you a better clue to my problem. Thanks for the reply SpacePhoenix.
Here you have to do some kind of advance dump: but I can't
dump if I can't even create a simple DB at the command-line.
I get the same type error ( Access denied for user ''@'localhost' to ... )
A POST: Am I able to open the world database using the command line within workbench?
I guest the answer was kind of still "yes". Now how sad is that?