Sorry you would use the name of the system, or the ip like so... (in pseudo terms) mysql -u yourpersonaluserid -p -h thehostiuse.com or mysql -u yourpersonalloginid -p -h ipaddress (such as 203.12.34.56)
sql query ~KB -----Original Message----- From: katherine bjork [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 4:13 PM To: Black, Kelly W [PCS] Subject: Re: mysql install---help please I typed in /usr/local/mysql/bin/mysql -u userid -p -h localhost password: prompted for password, gave only one I ever use response was ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) where userid was my login On Tuesday, March 25, 2003, at 03:50 PM, Black, Kelly W [PCS] wrote: > Try > > /usr/local/mysql/bin/mysql -u userid -p -h hostname > password: > > mysql> > > Regards, > > Kelly Black > > Linux was very clearly the answer, but what was the question again? > > > -----Original Message----- > From: Jennifer Goodie [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 25, 2003 3:16 PM > To: katherine bjork; mysql > Subject: RE: mysql install---help please > > > You said that you changed the password to the password you wanted, but > in > all the examples you are trying to access the server without a > password. > Try using the -p flag so it prompts you for your password, then type in > whatever you set the password to be. > > > -----Original Message----- > From: katherine bjork [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 25, 2003 3:02 PM > To: mysql > Subject: mysql install---help please > > > Tried for the second time to install mysql on my mac and again a > problem during the install related to the password. > > I typed in > > /usr/local/mysql/bin/mysqladmin -u root password 'new-password' > > and changed 'new-password' to the password I wanted. > > Got the --> > on the next line but nothing else so I assumed it worked. > > When I try to do anything such as check to see if mysql and php are > happy I get > > Warning: mysql_connect() [function.mysql-connect]: Access denied for > user: '[EMAIL PROTECTED]' (Using password: NO) in > /Library/WebServer/Documents/mysql_up2.php on line 5 > Warning: mysql_select_db() [function.mysql-select-db]: Access denied > for user: '[EMAIL PROTECTED]' (Using password: NO) in > /Library/WebServer/Documents/mysql_up2.php on line 9 > Warning: mysql_select_db() [function.mysql-select-db]: A link to the > server could not be established in > /Library/WebServer/Documents/mysql_up2.php on line 9 > Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) > > When I go back and try /usr/local/mysql/bin/mysqladmin -u root password > 'new-password' again I get > > /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' > failed > error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' > > Also tried > > /usr/local/mysql/bin/mysqladmin -u root -h $hostname password > 'new-password' > > but was denied. > > How the heck do I give myself access to mysql? > > Please don't point me to the mysql.org page...been there I do not > understand the "grants et al". Need plain english as in explicit > instruction on what to do. BTW version is 4 on mac osx running apache > 1.3 with php 4.3 > > Katherine > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
