Re: Connect to mysql?

I tried it and it worked. What does -h mean?

I have 2 (4) users for mysql and it is "root" (local and %) with a passord
and "cassandra" (local and %) without a password, that I did create a while
ago because someone did explain that I should do that. What is the
difference between these 2 users, root and cassandra? Which user should I
use and why? Should I have both users and should "cassandra" have a
password?

I tried to us DBDesigner 4 and I get error when I try to connect to a
database with "root" but not when I use "cassandra". Why?

Thanks





cd C:\Program Files\MySQL\MySQL Server 5.0\bin
mysql -h localhost -u root -p

use mindb

GRANT ALL PRIVILEGES ON *.* TO 'ODBC'@'localhost' IDENTIFIED BY 'yourpass'
WITH GRANT OPTION;


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!








.

Relevant Pages

  • Re: php 5 and MySql 5 - how to??
    ... combine PHP with MySql before. ... In order for the changes to take effect, you need to restart Apache. ... click the Apache symbol in the lower right-hand corner of your task bar. ...
    (alt.php)
  • Re: how to configure PHP5 to use MySQL in Windows XP
    ... I cannot use mysql_* functions because ... Call to undefined function mysql_connect ... PHP is problably not correctly configured to use MySQL. ... did you restart apache after changing your php.ini file? ...
    (comp.lang.php)
  • Re: I am totally stumped..with this on..LOAD_FILE Mysql+PHP= FSCK!!
    ... What I am trying to do is to upload files and stuff them in a mysql database. ... I copied the temporary file to somewhere else, and then handed it to MySQL..THAT WORKED.. ... Is there a way to force a close on the file..maybe that's the problem Mysql is opening a file that is not flushed to disk maybe? ... I gew the feeling its maintaining its own picture of file objects, and doesn't actually flush to the disk unless you do a copy or close php.. ...
    (comp.lang.php)
  • Re: I am totally stumped..with this on..LOAD_FILE Mysql+PHP= FSCK!!
    ... What I am trying to do is to upload files and stuff them in a mysql database. ... I copied the temporary file to somewhere else, and then handed it to MySQL..THAT WORKED.. ... Is there a way to force a close on the file..maybe that's the problem Mysql is opening a file that is not flushed to disk maybe? ... I gew the feeling its maintaining its own picture of file objects, and doesn't actually flush to the disk unless you do a copy or close php.. ...
    (comp.lang.php)
  • Re: com_dotnet
    ... And if MySQL isn't installed, the DLL won't load and phpinfowill show MySQL support isn't enabled. ... The MySQL interface is NOT compiled into PHP on the distributed Windows binaries - or you'd never be able to run PHP unless you had MySQL installed. ... *SOME* extensions are protocols, some are functional resources, and some are just type libraries. ... If you're going to compile the extension into PHP itself, the libraries must be available at compile time, and when you run PHP, or PHP won't load. ...
    (comp.lang.php)