You're using Windows, so I can't make any promises because this is what
I'd do under *nix, but when I first set up mySQL if I type:
# mysql -h localhost -p
The password will be denied, because no password is needed. So I'd
type:
# mysql -h localhost
And get in. This is under the /root/, and I can then:
mysql> USE mysql
mysql> UPDATE user SET password = password('pass') WHERE
username='root';
And, of course, on any created database I can
mysql> GRANT ALL PRIVILEGES ON some_db.* TO username;
mysql> FLUSH PRIVILEGES;
Disclaimer: I'm not looking at my reference card and typing rather
quickly so my syntax may be off a little here and there. Hope that
helps!
-Dan
On Tue, 2003-07-08 at 15:15, Kraig Olmstead wrote:
> If there's a FAQ I'm missing, please point me to it.
>
> v 4.0.13-NT
>
> I'm a C++ programmer trying to learn Java and JDBC (Java Database
> Connectivity). Obviously I need a database to bounce off in order to do
> that. Enter MySQL.
>
> I am going in through the command line shell. I am unable to do much
> because I don't seem to have privileges (e.g. create a database). The
> WinMySQLadmin 1.4 tool has my local user and host correct - i.e. they
> match what's in the "my ini Setup" tab of the same tool. I'm able to
> get in using that host and username, but whenever I try to use my
> password I am denied.
>
> I'm guessing that since I don't provide a password I'm some sort of a
> guest. The password I type in in the same as the one listed in the "my
> ini Setup" tab and the users match both that listed in the "Environment"
> tab and "my ini Setup" tab.
>
> My apologies in advance if I'm doing something stupid beyond words here
> or if this is something listed in a FAQ.
>
> I may simply uninstall/reinstall to verify that I have everything set up
> correctly.
>
> KO
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
