Re: Help!! Extreme newbie
what is the error message you are getting? Is the MySQL server running on the same machine you are trying to connect to or are you connecting to a remote machine? On Tuesday, September 3, 2002, at 09:40 PM, Al Davis wrote: SK > Being new to MYSQL as well as this list, I'm hoping you'll forgive what > I'm sure will be a rather "dumb" question... > I just installed mysql on a new install of SUSE 8.0 and every time I try > to connect to the mysql server as a non root use I am denied > access..have changed passwords, granted permissions, flushed permissions > and yet nothing seems to work... > > Any suggestions? > > Thanks, > Al Davis > AKA extreme mysql/linux newbie > > > - > 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
Re: Help!! Extreme newbie
Pada Tue, 3 Sep 2002 21:40:44 -0400 "Al Davis" <[EMAIL PROTECTED]> menulis : > Being new to MYSQL as well as this list, I'm hoping you'll forgive what > I'm sure will be a rather "dumb" question... > I just installed mysql on a new install of SUSE 8.0 and every time I try > to connect to the mysql server as a non root use I am denied > access..have changed passwords, granted permissions, flushed permissions > and yet nothing seems to work... you can't login from "non-root" shell account ? try to use mysql like this : shell> mysql -uroot and to assign mysql root password : shell> mysqladmin -uroot password "new-password-for-mysql-root-user" and to create new mysql user: mysql> grant all privileges on *.* to @ identified by ""; mysql> flush privileges; -- Write clearly - don't be too clever. - The Elements of Programming Style (Kernighan & Plaugher) MySQL 3.23.51 : up 74 days, Queries : 358.074 per second (avg). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790 Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.com - 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
Help!! Extreme newbie
Being new to MYSQL as well as this list, I'm hoping you'll forgive what I'm sure will be a rather "dumb" question... I just installed mysql on a new install of SUSE 8.0 and every time I try to connect to the mysql server as a non root use I am denied access..have changed passwords, granted permissions, flushed permissions and yet nothing seems to work... Any suggestions? Thanks, Al Davis AKA extreme mysql/linux newbie - 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
