Pada Tue, 3 Sep 2002 21:40:44 -0400
"Al Davis" <aldavis@stripped> 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
