Re: Access denied

[ian mc]

Ok, it seems that when you start the MySQL program from the command line
if you use the -u root switch ,,, so you start it like this:

C:\MYSQL\BIN>mysql -u root

then you can do

mysql> show databases

and you will see the mysql database, this also seems to allow the creation and manipulation of databases.

Took me ages to find this :) found it somewhere else in these forums.

I can't seem to get the winmysqladmin.exe program to see the other databases though but the MySqlManager.exe does (not that it seems to let you change anything)

I was going through a tutorial and created a database with several tables,,, i misspelled one of the tables, i don't know how to correct that but i suspect that it would mean creating the table with the correct spelling then copying all of the data from the old table to the new correct one and then deleting the old table.....

Not sure if i'm correct here, it may be that you have to do this when you make any changes to a table, if for example you wanted a new column you might have to:
create a new table with a different name and with the extra column
copy all of the data from the old to the new
delete the old
make a 'new' table with the same name as the old but including the extra column
copy everything from the 'temporary' new table to the one with the correct name and the extra column
delete the temporary table

phew!

databases eh? don't ya just luv em' :)

ian