Posted by news.telia.net on 10/04/21 11:52

Hi!

I have a question. I have installed php and mysql on an apache-server on
windows and I can't connect to the server.

I tried to create a database (since I am trying to learn howto). My manual
said I should write this at the shell:
c:\mysql\bin>mysqladmin -u root creare mindb

I did this and got this error:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

I then tried to use -p and wrote this instead:
c:\mysql\bin>mysqladmin -p -u root creare mindb

The database was created!

Then I tried to write mysql in cmd at c:\mysql\bin but I get this error:
Access denied for user 'ODBC'@'localhost' (using password: No)

Why??

I have used earlier versions of mysql and php and got it to work. In earlier
versions "my.ini" looks very different and user and password were written
there, but not anymore. Why, or is it me who have done something wrong? When
I log in to phpmyadmin I have to root-accounts there, one with
host=localhost and one the host=%.

All I want, is to make mysql work, so I can test things and to learn!

Thanks
Cassandra

My configuration


Windows XP pro

Netgear router (I have opened port 3306)

ADSL

no-ip (For my domain, www.kamrate.se)


Apache 2.2.2

The exe-files are in c:\apache2\bin

(All I did was to fill in domain=localhost, servername=localhost and my
email)


PHP 5.1.4

The exe-files are in c:\php

(I used the zip package)


httpd.conf

At the row below "#LoadModule ssl_module modules/mod_ssl.so" I wrote:

LoadModule php5_module "c:/php/php5apache2_2.dll


At the row below "AddType application/x-gzip .gz .tgz" I wrote:

AddType application/x-httpd-php .php


At the row below "DocumentRoot" I wrote:

PHPIniDir "C:/php"


At the row below "DocumentRoot" I wrote:

PHPIniDir "C:/php"


At the row "DirectoryIndex index.html" I wrote:

DirectoryIndex index.htm index.html index.php


php.ini

Changed "doc_root" to:

c:\Apache2\htdocs


Created a tmp-folder in:

c:\apache2\ and wrote the path in session.save_path:

c:\apache2\tmp


Saved php.ini in:

c:\php


I did restart apache and tested php and it worked!


Mysql 5.0.22

The exe-files are in c:\mysql\bin


Removed earlier versions of mysql, including the folder:

c:\mysql


I did choose to run "Configuration Wizard" and did choose a password for
root.


PhpMyAdmin

Installationfolder is "c:\apache2\htdocs"

I wrote host=localhost, user=root and password in config.inc.php.


php.ini

I removed the ; before "extension=php_mysql.dll"

I removed the ; before "extension=php_mbstring.dll"


At the row "extension_dir" I wrote:

extension_dir="c:\php\ext"


I copied libmysql.dll in c:\mysql\bin to:

c:\apache2\bin


I did restart apache and tested to surf to http://localhost/phpmyadmin and
it worked!

• Next in forum: Re: Inserting NULL into a smalldatetime
• Prev in forum: how do I drop a foreign key in MySQL 4
• Thread view: Connect to mysql?

[Reply to this message]