Data loading and foreign key constraints - help please

I'm a total newbie to mySQL, but was hoping someone could answer a question regarding adding a record into a database that has foreign key constraints. Remember, I'm a total newbie so I'm hoping I'm using the right words to express this. I'm taking a class that required us to use an ER

root without permissions...

Hello, these are my first days with mySQL. Yesterday all is well. Today i changed some permissions in the databases and groups. I think i have returned to the original permissions, but i not have any permission with the user root. Is possible to restore this user?: **login with my passw - [EMAIL

Re: root without permissions...

Jose: It looks like you can log in to the mysql client as root. Do you have permission to change the password once you're logged in? [EMAIL PROTECTED] jusoz]$ mysql -u root -p Enter password: Welcome to the MySQL monitor... mysqlUSE mysql; Database changed. mysqlUPDATE user SET Password =

Re: root without permissions...

It looks like you can log in to the mysql client as root. Do you have permission to change the password once you're logged in? [EMAIL PROTECTED] jusoz]$ mysql -u root -p Enter password: Welcome to the MySQL monitor... mysqlUSE mysql; Database changed. mysqlUPDATE user SET Password =

RE: Access denied for root user

From: Michael Stassen [mailto:[EMAIL PROTECTED] Subj: Re: Access denied for root user MueR wrote: Hello, I've recently had my HD crash, and have reinstalled everything. Everything seems to work fine, apart from one thing. My MySQL server has decided to randomly set a root password.

how to turn on auditing for mysql

Is there any way to log all the activity in a mysql database? I would like to know every single delete insert or select on all tables for my database. Regards, Alex

Re: InnoDB table creation

Hi Michael, I made some changes to the sql statments to create the ENROLLS table as follows: CREATE TABLE ENROLLS (courseID SMALLINT NOT NULL, sectionID SMALLINT NOT NULL, studentID SMALLINT NOT NULL, grade SMALLINT)TYPE=INNODB; PRIMARY KEY(courseID,sectionID,studentID), INDEX(courseID), FOREIGN

Re: slow select... where... order by

Dave, It's best to keep threads on the list. On average, you'll get better and faster responses when all the experts can see your question. Also, others can benefit from the answers when they are on the list. See my comments below. Critters wrote: Thanks for your response, here is some more

RE: OT Gmail

As I have received many more than 3 requests I thought I should post this: You can get invitations to gmail for about 99 cents on ebay! That's where I got mine. I then sold a couple, but it's too much hassle for too little money! Anyway I hope some of you can get yours there, as I have not

Re: InnoDB table creation

Mulugeta Maru wrote: Hi Michael, I made some changes to the sql statments to create the ENROLLS table as follows: CREATE TABLE ENROLLS ( courseID SMALLINT NOT NULL, sectionID SMALLINT NOT NULL, studentID SMALLINT NOT NULL, grade SMALLINT)TYPE=INNODB; ^ You

Re: OT Gmail

Transcend Development wrote: -- From: Transcend Development[SMTP:[EMAIL PROTECTED] Sent: Sunday, August 29, 2004 6:30:01 PM To: [EMAIL PROTECTED] Subject: RE: OT Gmail Auto forwarded by a Rule As I have received many more than 3 requests I thought I should post this:

Re: InnoDB table creation

--- Michael Stassen [EMAIL PROTECTED] wrote: Mulugeta Maru wrote: Hi Michael, I made some changes to the sql statments to create the ENROLLS table as follows: CREATE TABLE ENROLLS ( courseID SMALLINT NOT NULL, sectionID SMALLINT NOT NULL, studentID SMALLINT NOT

Re: Access denied for root user

MueR wrote: From: Michael Stassen [mailto:[EMAIL PROTECTED] Subj: Re: Access denied for root user MueR wrote: Hello, I've recently had my HD crash, and have reinstalled everything. Everything seems to work fine, apart from one thing. My MySQL server has decided to randomly set a root password.

Re: OT Gmail

I have 7 invitations to give away. Feel free to ask, but include a sentence about why you want it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: root without permissions...

On Sun, 29 Aug 2004 12:26:25 -0400 Wesley wrote: Exit mysql. OK, then that would seem to mean that you don't have a root user with 'localhost' as an allowable host. As long as you can ^^ log in as jusoz, see if you can issue this: Thanks !!! localized the

Re: InnoDB table creation

Mulugeta Maru wrote: --- Michael Stassen [EMAIL PROTECTED] wrote: Mulugeta Maru wrote: Hi Michael, I made some changes to the sql statments to create the ENROLLS table as follows: ** Did you read this part? ** CREATE TABLE ENROLLS ( courseID SMALLINT NOT NULL, sectionID SMALLINT NOT

Re: OT Gmail

Miles Keaton wrote: I have 7 invitations to give away. Feel free to ask, but include a sentence about why you want it. I have 6 invitations to give away. Available to the first 6 who ask. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: OT Gmail

On Sunday 29 August 2004 19:24, Mike Wexler wrote: Miles Keaton wrote: I have 7 invitations to give away. Feel free to ask, but include a sentence about why you want it. I have 6 invitations to give away. Available to the first 6 who ask. It might be possible to take this off list, no? ;-)

Re: OT Gmail

Beware guys! When I sent this message, I think google got a hold of it and I can't receive any mail at this address anymore. If you get an invite and you get to invite friends - DON'T SELL THEM!!! It is against their AUP. You've been warned! Cheers! Richard On Sun, 29 Aug 2004 09:30:01

Re: InnoDB table creation

I am sorry. I did not remove TYPE=INNODB in the middle of the statment. You are right. I am now getting a different error message; ERROR 1005 at line 33: Can't creat table '.\enrollment1\enrolls.frm' (errno: 150) All the tables except enrolls is created. What am I doing wrong again? Regards.