MySQL Forums
Forum List  »  Install & Repo

Re: Access denied
Posted by: ian mc
Date: October 12, 2004 12:01PM

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


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


Options: ReplyQuote

Written By
October 12, 2004 05:31AM
October 12, 2004 10:02AM
Re: Access denied
October 12, 2004 12:01PM
October 13, 2004 01:57AM
October 14, 2004 10:12PM
October 21, 2004 09:12PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.