sample database

2002-02-01 Thread Luie delos Santos
I'm trying to create a database system for our school and since 'm still new to MySQL, I'm wondering if there are any sample databases (student registration/enrollment information, employee payroll, etc.) published in the internet so that I can have some idea on how to go about developing our o

man pages for MySQL

2002-01-31 Thread Luie delos Santos
Hello all, I'm just wondering, is there a man pages for MySQL? Like the one that we use in linux, executing *man ls*, for example, in the command line provides some detail on how to use the command. Is there a similar method for MySQL where we can execute *man grant*, for example? thanks... l

Re: Access denied for user varlehti

2002-01-25 Thread Luie delos Santos
>LdS> I'm experiencing the same problem. >LdS> But I sort of found a way around it (though I'm sure this is not really the >right way). >LdS> When I "remove" the *password* for *root* and login again as root, I'm able to >create new users using GRANT then flush priviliges. >LdS> Does this mean

can login only as root

2002-01-19 Thread Luie delos Santos
hello all, I recently installed mysql on a RedHat7.2 box. I was able to login to it as *root*. I created another user (user1) using "GRANT all to user1 identified by 'password';", but when I tried to login as *user1*, access denied message is displayed. I've tried *flush privileges* but I'm st