Regarding MySql

--0-2111011394-1122551988=:18831
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hello...!
I installed my sql from CD with the book. But having problems which are not explained in the book. I also refer to Mysql online manual.
I am very new to programming.. So, plz help..
I have also added mysql/bin path to environment variables (using win xp)
First I start mysqladministrator, then I type mysqld on command prompt. It's ok upto this.
But when I try to create database, it gives me error like access denied to user @localhost. (command used: mysqladmin create testData)
So, please tell me what to do..Also, mysqladministrator is not showing any database drivers in its window (like *odbc.dll) can this create problem to me if I try to connect it to JAVA.

Also, what should in winnt\my.ini file if mysql directory is c:\mysql? is it ok (given below)
[mysqld]
basedir=c:/mysql/
datadir=c:/mysql/data

Kindly do the needful.
Regards.
..Mohit

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--0-2111011394-1122551988=:18831--

Re: Regarding MySql

On 7/28/05, Mohit Deshpande wrote:
> Hello...!
> I installed my sql from CD with the book. But having problems which are n=
ot explained in the book. I also refer to Mysql online manual.
> I am very new to programming.. So, plz help..

CD? Well, as far as I know there's no CD distribution, at least not
official, so, you better download the latest version from the mysql
site, along with the manual, I suggest the pdf version.

> I have also added mysql/bin path to environment variables (using win xp)
> First I start mysqladministrator, then I type mysqld on command prompt. I=
t's ok upto this.
> But when I try to create database, it gives me error like access denied t=
o user @localhost. (command used: mysqladmin create testData)

You need more knowledge on how MySQL works, the mysqld is the server,
("d" stands for daemon), if you're using a service enable win OS, then
you should start MySQL as a service, not from the command prompt.
MySQL Administrator administer the services too, you can use it to
create and start/stop the service, you can edit the configs (the ini
or cnf file) directly with it, but I advice you to write your own
config file. Mysqladmin is not meant to give mysql commands, you do
that using the client (the "mysql" program) or any GUI around. If you
read the output of mysqladmin, it is "Administration program for the
mysqld daemon."

> So, please tell me what to do..Also, mysqladministrator is not showing an=
y database drivers in its window (like *odbc.dll) can this create problem t=
o me if I try to connect it to JAVA.
>=20

Java has its own designed API for download at the mysql site, used to
connect to MySQL, it has its own features and has nothing to do with
the server, I mean, if its running and you can connect to it, the
server really don't care about WHAT are you using to connect. Check
the JDBC driver.

> Also, what should in winnt\my.ini file if mysql directory is c:\mysql? is=
it ok (given below)
> [mysqld]
> basedir=3Dc:/mysql/
> datadir=3Dc:/mysql/data
>=20
> Kindly do the needful.
> Regards.
> .Mohit
>=20

Looks good to me, very basic and short, should work if you don't have
special network needs.

For further information, please refer to the MySQL Manual, download
the latest, both manual and mysql version, and follow it, its all
there.

--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org