Hi Barry, 2003年 5月 31日 土曜日 00:30、あなたは書きました: > Thanks Nils. I can remotely connect to the database. I removed the local > host entries for the bdancis account (the same name as the remote login) > and added a new entry for [EMAIL PROTECTED] but was still not able to log on > locally even if I run: > > grant select on mysql.* to [EMAIL PROTECTED];
About aboves command: This grant will allow barry to select only information from the 1 database named mysql - which is the database containing the user privileges. This person will not be able to edit any data that exist in any other database. I still think you missed the correct settings. I think you have 2 problems right now: 1) you still might have an anonymous user account on your system, which might also take precedence over your settinga for the local connection of bdancies. 2) The access privileges are not set correctly. Perhaps its a good idea to take a look at some documentation f.e. the mysql info manual or http://www.devshed.com/ has some good tutorials on the mysql privilege system. It helped me a lot to understand how the mysql privilege system works. > > which gives: > > ERROR 1133: can't find any matching row in the user table > > Select * from user where user='barry' > > does give 1 row > > Adding an entry into mysql.db does not help the granting of privs or the > ability to login. > > Since I can connect remotely and that is what I really needed I am > going to ignore the local logon issues for now. > > Separately, when I am querying using mysqlcc, it only returns the first > record. For 1 table with 12 records, select * gives: I got this error when wanting to view tables from the mysql privilege database (named mysql) I had the same problems, that seems to be a bug. > > [ENSEMBL] ERROR 1104: The SELECT would examine too many records and > probably take a very long time. Check your WHERE and use SET OPTION > SQL_BIG_SELECTS=1 if the SELECT is ok > > If SQL_BIG_SELECTS is 1, I get back 1 record. If it is 0 or default I get > the error > > Any thoughts on how to get more records. > > Thanks, > > Barry > > -----Original Message----- > From: Nils Valentin [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 29, 2003 8:45 PM > To: Dancis, Barry PH/US/EXT; [EMAIL PROTECTED] > Subject: Re: Creating new users > > > Hi Barry, > > > I believe you miss an important point. You have to check the privileges you > gave the user or host that doesnt work. > > login to mysql from a working account. > > do this: > > USE mysql > SHOW GRANTS FOR bdancies; > > loook exactly what it says. > If you are used to mysqlcc than connect from there look at the data in all > tables of the mysql database. They contain the privilege of each user or > host. > there should be 5 tables f.e. > > mysql.user > mysql.host > mysql.columns_priv > mysql.tables_priv > mysql.db > > When you setup localhost and a remote login for the same user than it > depends on the order of this 2 entries within the mysql database. > > I think you have all informatioin required now. > > Good Luck !! > > Best regards > > Nils Valentin > Tokyo/Japan > > 2003年 5月 30日 金曜日 03:[EMAIL PROTECTED] さんは書きました: > > Hi -- > > > > I am trying to connect to a remote mysql database on a unix machine > > from a MySql control center on a Wintel machine, but I get the following > > error: > > > > [ENSEMBL] ERROR 1045: Access denied for user: > > '[EMAIL PROTECTED]' (Using password: YES) > > > > When I am logged onto the unix box, I can log into MySql as root. I > > have added a user (bdancis), a host ('wintelhost.company.com' ) and the > > same password as for the root and I can't log in. Maybe the problem is > > the remote login so I set up another new user (bdancis) for localhost and > > I can't log in from the unix box where I have just logged in as root. I > > have set all the privs where user.user = 'bdancis' to 'Y'. I have also > > tried other hosts ('wintelhost.company' and 'wintelhost') without > > success. > > > > > > Any suggestions? > > > > Thanks, > > > > Barry -- ================================================ Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp ================================================ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
