Re: Access denied on use mysql;

2002-03-22 Thread Liyju Janardhan
--- Kathy Reyes <[EMAIL PROTECTED]> wrote: > Now I have a different problem. When I type mysql it > gives me the message > Access denied for user: 'root@localhost' (Using > password: NO) > how do I get it to use the password. > When I type mysql -u root -p > I get in... ^ What do you mea

Re: How to connect to mysql databases

2002-03-21 Thread Liyju Janardhan
Do the folowing mysql>show grant for root@localhost; mysql>grant all on test.* to root@localhost identified by 'password'; $mysqladmin reload --- amol sonaikar <[EMAIL PROTECTED]> wrote: > There is still error > > I did as per your say > at mysql> use test; but the error it gave was > ERROR

Re: How to connect to mysql databases

2002-03-21 Thread Liyju Janardhan
what is the output of "show database" command --- amol sonaikar <[EMAIL PROTECTED]> wrote: > Hi all . I am on a Linux 6.2 client and accessing > MySql directly on > the server. I have connected to server using Telnet. > I am at mysql> > prompt > and when I say show databases ; it showing me th

Re: Java to MySQL connection

2002-03-21 Thread Liyju Janardhan
which Driver your using? which Operating system your using? If your using linux, as far as I know there is now odbc support. You have to downlaod mm.mysql driver. If your are using windows you will have to create a dsn name for the your selected driver. --- Chris Stewart <[EMAIL PROTECTED]> wr

Re: Fw: Access denied on use mysql;

2002-03-21 Thread Liyju Janardhan
Hi, Check whether ur mysql is running using the following command. $/etc/rc.d/init.d/mysqld status if the reply is running... then type 'mysql' (if you have anonymous login) otherwise type 'mysql -u root -p' If you don't get the mysql prompt then you will have to add an user using mysqladmi

Re: Access denied on use mysql;

2002-03-18 Thread Liyju Janardhan
--- alan4100 <[EMAIL PROTECTED]> wrote: > The problem begins when I type in use mysql; > Please look at the very left edge with three > asterisks..*** where I marked. ACCESS denied > Hope it will be fixed with your help so I can mind > my own chores. > > =