Posted by strawberry on 06/30/06 05:42

What's creare? Is that the password? (If so then change it!)

at the command prompt

C:> or C:/.../mysql/bin

assuming 'root' is still a valid user

what happens if you type

mysql -u root -p

?

news.telia.net wrote:
> 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!

[Back to original message]