Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle equivalent of MySql commands and code.

539484Oct 13 2006 — edited Oct 17 2006
Hi,

Does anyone know the Oracle equivalent of the following? I'm not a DBA and my DBA doesn't know MySQL. TIA

Assign access rights: login as root user to mysql:

mysql -uroot -pYourSecretPassword

On some MySQL installations, the root user has no password, in that case drop
the -p parameter.

Then grant the necessary access rights using the following commands: (this will
automatically create the users)

GRANT ALL ON daisyrepository.* TO daisy@"%" IDENTIFIED BY "daisy";
GRANT ALL ON daisyrepository.* TO daisy@localhost IDENTIFIED BY "daisy";

(The localhost entries are necessary because otherwise the default access rights
for anonymous users @localhost will take precedence.)

and create the database using:

CREATE DATABASE daisyrepository;

jack
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 14 2006
Added on Oct 13 2006
21 comments
1,631 views