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 <username>@<localhost/hosts> identified by "<password>"; 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