> > this is my first question:
> >
> > when i try connect since a client windows9x to mysql (in a server linux rh 7.0),
>say me the next error:
> >
> > General Sql Error: [TCX][MyODBC]Access deneied for user [EMAIL PROTECTED] (using
>password YES) alias Test
>
> You must grant user rights to mysql first.
>
> use mysql console (eventually on server itself):
>
> mysql -u root -p
> mysql> GRANT ALL ON *.* TO 'myname'@'192.168.1.1' IDENTIFIED BY 'a_password';
> mysql> flush privileges();
first: in the line: flush privileges(); the correct statment is: flush privileges;
second: i try connect since my client win98 (i build an Delphi app), but say me the
next error:
Key Violation [TCX][MyODBC] Access Deneied for user 'root'@'192.168.1.197' (using
password YES) alias Test
NOTES: i have configured my user dsn:
Windows DSN name: test
MySQL Host (name or IP): 192.168.1.1
MySQL Databasename: firstdb
User: root
Password: 123456
Options checked's: don't Optimize column width and Return Matching rows
the system Dsn is same...
my server have the next adress: 192.168.1.1
thanks
-----------------------------------------------
Runbox Mail Manager - www.runbox.com
Free online email application
---------------------------------------------------------------------
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