### db set up [Linux]> mysql -h localhost -u root mysql> create database db_abc;
### grant to user mysql>grant all on db_abc.* to pp@localhost -> identified by 'pp_pwd'; ### ppp login [Linux]> mysql -h localhost -u pp -p db_abc this is what I had done, have a look the message is becoming messy, may be I made a mistake about how u check the login :) Borus (leaving office, cu) > Yes - but I haven't got the picture of what you're trying to communicate. > > I thought I would have to log in as root, to be able to create the user cbaa > and allow that user to access the cbaa database. > > Ian > ----- Original Message ----- > From: "ÅÇ´f¼Ù (Borus.Kung)" <[EMAIL PROTECTED]> > To: "Ian Phillips" <[EMAIL PROTECTED]> > Sent: Monday, April 22, 2002 10:23 PM > Subject: Re: New Setup > > > > I found that you Grant to cbaa user but use root to login > > check it > > > > Borus ;) > > > > > > > > > Thanks for the idea -- still stuck though > > > > > > Tried connecting to mysql using the -h option, but I still had the same > > > response. (with the -p option as well thanks Borus). Let me check - > > > "Your_Server_Name" I think in my case is localhost > > > > > > I had a look (using the phpMyAdmin tool) at the records in the user > table. > > > There are four records - two of which are localhost - one which is root, > > > with password (all privileges), and the second no user & no password - > no > > > privileges. The other two records are similar, but my server's domain > name > > > appears in these two records. > > > > > > I could not see any % mark in the user table - however I did find the % > > mark > > > in the mysql.host table - two records - one for localhost and the other > my > > > domain name, and the % mark was in the db column. > > > > > > Ian > > > > > > ----- Original Message ----- > > > From: "Gelu" <[EMAIL PROTECTED]> > > > To: "Ian Phillips" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > > Sent: Monday, April 22, 2002 9:05 PM > > > Subject: Re: New Setup > > > > > > > > > > Hi, > > > > Only the root with the '%' character on the host field from table > > > mysql.user > > > > have full priveleges.Try to connect with "-h" option and specify the > > > > Host_Name of your server.Should be work. > > > > Eg: mysql -u root -h Your_Server_Name > > > > Regards, > > > > Gelu > > > > _____________________________________________________ > > > > G.NET SOFTWARE COMPANY > > > > > > > > Permanent e-mail address : [EMAIL PROTECTED] > > > > [EMAIL PROTECTED] > > > > > > > > ----- Original Message ----- > > > > From: Ian Phillips <[EMAIL PROTECTED]> > > > > To: <[EMAIL PROTECTED]> > > > > Sent: Monday, April 22, 2002 11:58 AM > > > > Subject: New Setup > > > > > > > > > > > > > I thank anyone in advance who may be able to help me iron this out. > > > > > > > > > > 1. I am setting up mysql on my apache server. I have had it there > for > > a > > > > > while, but haven't really done much with getting my head round it. > > > > > > > > > > 2. I have figured out some shell commands, and have been able to set > a > > > > root > > > > > password. > > > > > > > > > > 3. I have also been able to use phpMyAdmin - which I had to modify > to > > > take > > > > > into account the root password etc that is now in place. > > > > > > > > > > 4. I can create a database & table using the phpMyAdmin forms - and > it > > > was > > > > > relatively easy. However, when I go back to try and set up a new > user > > > who > > > > > has permission to do a range of things on this database, (using > shell > > > > now), > > > > > I am given an error.... > > > > > > > > > > ERROR 1044: Access denied for user: 'root@localhost' to database > > 'cbaa' > > > > > > > > > > Shell command I am using.... > > > > > > > > > > mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP > > > > > -> ON cbaa.* > > > > > -> TO cbaa@localhost > > > > > -> IDENTIFIED BY 'itsmeolord'; > > > > > > > > > > This seems strange to me, as I figured that root would have > permission > > > to > > > > do > > > > > anything (even if it were 'inappropriate'. > > > > > > > > > > Any guidance would be appreciated. > > > > > > > > > > Ian > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > Before posting, please check: > > > > > http://www.mysql.com/manual.php (the manual) > > > > > http://lists.mysql.com/ (the list archive) > > > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > Before posting, please check: > > > > http://www.mysql.com/manual.php (the manual) > > > > http://lists.mysql.com/ (the list archive) > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php