I"m having probs with MySQL, can someone assist me? :)

-------------------------------1110850213
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

Hello everyone.

I'm starting out in PHP, installed the necessary files, and all seems fine -
I can run simple
programs, however, connection to MySql, seems to be a little bit of a task
here as I can not
see what is wrong - after all, all I have done is unzip the file into:
C/mysql/temp, then from the
temp file, I executed the mysql.exe file to install MySQL 3.23.58 as 5.1.10
didn't help
much with apache version 2 as appposed to the 1.33 which I swiched back to,
to get
PHP4 working.

I set a temp password for the main override (admin) as:
admin = user name
adminpass = p/w

and these are the errors I receive... but before I do, this is my my.ini
file. when I started
the MySQL console before, it read me as being localhost 127.0.0.1 but now,
my normal
isp address, strange, but I can't work out why there are no databases in my
SQL tables
or create, set permissions, delete anonymous admin, etc.

#This File was made using the WinMySQLAdmin 1.4 Tool
#3/15/2005 12:18:31 AM

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/mysql
bind-address=127.0.0.1
datadir=C:/mysql/data

port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=admin
password=adminpass
QueryInterval=10
=========

mysql prompt read out.


Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\mysql\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.58-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show tables;
ERROR 1046: No Database Selected
mysql> create database test;
ERROR 1044: Access denied for user: _'@localhost'_ (mailto:'@localhost') to
database 'test'
mysql> -h localhost -u admin -p
-> adminpass;
ERROR 1064: You have an error in your SQL syntax near '-h localhost -u admin
-p
adminpass' at line 1
mysql> -h localhost -u admin -p;
ERROR 1064: You have an error in your SQL syntax near '-h localhost -u admin
-p'
at line 1
mysql> create databse test;
ERROR 1064: You have an error in your SQL syntax near 'databse test' at line
1
mysql>

I can't seem to find out what the problem is....
can any one help me pls?
What is the best version of apache, Mysql and PHP to use and any fixes to
above?

Thanks kindly ppl for your help...

best regards.

litchcockbell.

-------------------------------1110850213--

Re: I"m having probs with MySQL, can someone assist me? :)

Try this (from the command prompt):

C:\mysql\bin>mysql -h localhost -u admin -p

I'm using version 4.0.13-nt-log. mysql.exe doesn't seem to take the passwor=
d from the command line, but it does ask for the password when it starts up=
..

Basically, you are connecting to the mySql server as an anonymous user, as =
such you have limited rights and privileges. None of this has anything to d=
o with Apache or PHP. That's a whole other ball of wax.

Hope this helps.

Randy Clamons
Systems Programming
Novaspace.com


> ------------Original Message------------
> From: Litchcockbell@aol.com
> To: win32@lists.mysql.com
> Date: Mon, Mar-14-2005 6:30 PM
> Subject: I'm having probs with MySQL, can someone assist me? :)
>
> Hello everyone.
> =

> I'm starting out in PHP, installed the necessary files, and all seems =

> fine - =

> I can run simple
> programs, however, connection to MySql, seems to be a little bit of a =

> task =

> here as I can not
> see what is wrong - after all, all I have done is unzip the file into: =

> =

> C/mysql/temp, then from the
> temp file, I executed the mysql.exe file to install MySQL 3.23.58 as =

> 5.1.10 =

> didn't help
> much with apache version 2 as appposed to the 1.33 which I swiched =

> back to, =

> to get
> PHP4 working.
> =

> I set a temp password for the main override (admin) as:
> admin =3D user name
> adminpass =3D p/w
> =

> and these are the errors I receive... but before I do, this is my =

> my.ini =

> file. when I started
> the MySQL console before, it read me as being localhost 127.0.0.1 but =

> now, =

> my normal
> isp address, strange, but I can't work out why there are no databases =

> in my =

> SQL tables
> or create, set permissions, delete anonymous admin, etc.
> =

> #This File was made using the WinMySQLAdmin 1.4 Tool
> #3/15/2005 12:18:31 AM
> =

> #Uncomment or Add only the keys that you know how works.
> #Read the MySQL Manual for instructions
> =

> [mysqld]
> basedir=3DC:/mysql
> bind-address=3D127.0.0.1
> datadir=3DC:/mysql/data
> =

> port=3D3306
> #set-variable=3Dkey_buffer=3D16M
> [WinMySQLadmin]
> Server=3DC:/mysql/bin/mysqld-nt.exe
> user=3Dadmin
> password=3Dadminpass
> QueryInterval=3D10
> =========3D
> =

> mysql prompt read out.
> =

> =

> Microsoft Windows XP [Version 5.1.2600]
> (C) Copyright 1985-2001 Microsoft Corp.
> =

> C:\mysql\bin>mysql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 4 to server version: 3.23.58-nt
> =

> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> =

> mysql> show tables;
> ERROR 1046: No Database Selected
> mysql> create database test;
> ERROR 1044: Access denied for user: _'@localhost'_ =

> (mailto:'@localhost') to =

> database 'test'
> mysql> -h localhost -u admin -p
> -> adminpass;
> ERROR 1064: You have an error in your SQL syntax near '-h localhost -u =

> admin =

> -p
> adminpass' at line 1
> mysql> -h localhost -u admin -p;
> ERROR 1064: You have an error in your SQL syntax near '-h localhost -u =

> admin =

> -p'
> at line 1
> mysql> create databse test;
> ERROR 1064: You have an error in your SQL syntax near 'databse test' =

> at line =

> 1
> mysql>
> =

> I can't seem to find out what the problem is....
> can any one help me pls?
> What is the best version of apache, Mysql and PHP to use and any fixes =

> to =

> above?
> =

> Thanks kindly ppl for your help...
> =

> best regards.
> =

> litchcockbell.
> =



--
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

Re: I"m having probs with MySQL, can someone assist me? :)

-------------------------------1110853303
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit


Hi Randy, thanks for the reply :)

I tried this, and I receive this error:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\enigma>cd..

C:\Documents and Settings>cd..

C:\>cd mysql/bin

C:\mysql\bin>mysql -h localhost -u admin -p
Enter password: *********
ERROR 1045: Access denied for user: _'admin@localhost'_
(mailto:'admin@localhost') (Using password: YES)

C:\mysql\bin>mysql -h localhost -u admin -p
Enter password: *********
ERROR 1045: Access denied for user: _'admin@localhost'_
(mailto:'admin@localhost') (Using password: YES)

C:\mysql\bin>

I set admin user password as adminpass, as it states in my.ini file also...
but it still not
let me connect...

yours, still confused, and many thanks. :)

Litchcockbell. :)

In a message dated 3/15/2005 1:55:14 AM GMT Standard Time,
randy@novaspace.com writes:

Try this (from the command prompt):

C:\mysql\bin>mysql -h localhost -u admin -p

I'm using version 4.0.13-nt-log. mysql.exe doesn't seem to take the password
from the command line, but it does ask for the password when it starts up.

Basically, you are connecting to the mySql server as an anonymous user, as
such you have limited rights and privileges. None of this has anything to do
with Apache or PHP. That's a whole other ball of wax.

Hope this helps.

Randy Clamons
Systems Programming
Novaspace.com





-------------------------------1110853303--

Re: I"m having probs with MySQL, can someone assist me? :)

The password stored in the my.ini has nothing to do with the root
password of the actual server. By default on a clean install, the root
password is null; you do not need to enter an administrator password.
Check the manual on "post installation steps for windows" and it
explains all this clearly, and how to connect/change the root password
from null to something of your choosing. When you are in the
C:\mysql\bin folder all you should need to do is type (on the local
machine):

mysql -u root mysql

And it will let you in as the root user. Then you need to change the
root user password and then the next time you connect you can use the
process below with the password you specify above. Cheers.

Armando

Litchcockbell@aol.com wrote:
>
> Hi Randy, thanks for the reply :)
>
> I tried this, and I receive this error:
>
> Microsoft Windows XP [Version 5.1.2600]
> (C) Copyright 1985-2001 Microsoft Corp.
>
> C:\Documents and Settings\enigma>cd..
>
> C:\Documents and Settings>cd..
>
> C:\>cd mysql/bin
>
> C:\mysql\bin>mysql -h localhost -u admin -p
> Enter password: *********
> ERROR 1045: Access denied for user: _'admin@localhost'_
> (mailto:'admin@localhost') (Using password: YES)
>
> C:\mysql\bin>mysql -h localhost -u admin -p
> Enter password: *********
> ERROR 1045: Access denied for user: _'admin@localhost'_
> (mailto:'admin@localhost') (Using password: YES)
>
> C:\mysql\bin>
>
> I set admin user password as adminpass, as it states in my.ini file also...
> but it still not
> let me connect...
>
> yours, still confused, and many thanks. :)
>
> Litchcockbell. :)
>
> In a message dated 3/15/2005 1:55:14 AM GMT Standard Time,
> randy@novaspace.com writes:
>
> Try this (from the command prompt):
>
> C:\mysql\bin>mysql -h localhost -u admin -p
>
> I'm using version 4.0.13-nt-log. mysql.exe doesn't seem to take the password
> from the command line, but it does ask for the password when it starts up.
>
> Basically, you are connecting to the mySql server as an anonymous user, as
> such you have limited rights and privileges. None of this has anything to do
> with Apache or PHP. That's a whole other ball of wax.
>
> Hope this helps.
>
> Randy Clamons
> Systems Programming
> Novaspace.com
>
>
>
>
>

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

Re: I"m having probs with MySQL, can someone assist me? :)

-------------------------------1110855911
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

Thanks for the info Armando,

I can login with the username 'root' no problem, which i know needs no
password to access
d/b tables opon installation.

What confusing me, is, when I start the install it asks me for the username
and password for new users (recommended). so I do that, then enter the mysql
prompt and enter those details in which was asked of me during the install
process, but that username and password don't work, yet, the 'root' username
does. why is that?

urs, still a little confused,

many thanks

litchcockbell. :)

-------------------------------1110855911--

Re: I"m having probs with MySQL, can someone assist me? :)

I suspect you're using mysql 4.1 or 5? I actually just downloaded and
used the 4.0.x zipped package and did a manual install then setup my
users manually as well so I am not familiar with the installer process.

You can always check your users/permissions by first getting into the
database as the root user, then querying the user table to see what's
all in it, ie; select * from user

That should tell you all you need to know. Pay particular attention to
the user and password fields to make sure they are populated with
information. Start there and see what you get. Cheers.

Armando


Litchcockbell@aol.com wrote:
> Thanks for the info Armando,
>
> I can login with the username 'root' no problem, which i know needs no
> password to access
> d/b tables opon installation.
>
> What confusing me, is, when I start the install it asks me for the username
> and password for new users (recommended). so I do that, then enter the mysql
> prompt and enter those details in which was asked of me during the install
> process, but that username and password don't work, yet, the 'root' username
> does. why is that?
>
> urs, still a little confused,
>
> many thanks
>
> litchcockbell. :)
>

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