login on sql DB problem

i see your using mysql...

please check your status and print the results here to let me see where your going wrong in the above code and if you can , could you please print the page code that connects to db....

if you dont know how to check your status, do this:

Start > run > type cmd or command and hit [enter]

browse to your mysql folder on c drive or whereever you have it stored.

enter mysql and type 'status'. this will print out your status.

example:

C:\
C:\mysql
mysql>
mysql>status

sean

I have to browse to my mysql folder in comand prompt? I'm affraid I can't do that :-s

ow... ok I've got it... new question how do you create a mysql database? :-)

conection id: 1
current database:
current user: root@localhost
ssl: not in use
server version: 4.0.21-nt-log
protocol version: 10
connection: local host via tcp/ip
port: 3306

voila

mysql database created... still the same problem if I try the php script

DB Error: not found

post your code?

<<< I have to browse to my mysql folder in comand prompt? I'm affraid I can't do that :-s

why cant you do this?

to create a db in mysql using php:

<?php
$link = mysql_connect("localhost","odbc","123456789");
if (!$link)
      die("Couldn't connect to MySQL");
else
      mysql_query("CREATE DATABASE secure") or die ("Error: ".mysql_error());
mysql_close($link);
?>

where localhost is your server so for the results you posted above, let this the same!
odbc is the user, in your case, its root
and 123456789 is the password you use to connect to mysql.

if you are having problems with passwords etc, i can help you with this too.

so in your case to createa  db in mysql using php use this:

<?php
$link = mysql_connect("localhost","root","YOUR_PASSWORD_HERE");
if (!$link)
      die("Couldn't connect to MySQL");
else
      mysql_query("CREATE DATABASE YOUR_DB_NAME_HERE") or die ("Error: ".mysql_error());
mysql_close($link);
?>

i have a full example for mysql/php for download if you want it.

it creates drops dbs, create tables, updates, add, drops records in mysql using php scripts...

can you create, alter, update & drop databases just using the mysql management console without any problems? or are your problems just in php scripts?

p.s are you studying computing?

so am i, 2 yrs left...

i have to go now, but you can download some scripts i wrote for mysql/php at

http://www.freewebs.com/seandelaneydownloads/mysql.zip

hope i could help

will check back in the morning

Sean

I have no problem with creating, switching between dropping DB'ses with the msql console ... wut if I want to connect with the PHP script I get the error
DB Error: not found
my variables for connecting are defined above... the database is created correctly but I just can't connect via PHP...
(and I'm senior highschool... PC , databases software etc are just a hobby)

nope for me its my job!

so whats the error now?

look back at my post for 03/13/2005 09:30PM GMT

if you are still having problems connecting, post your code or a screen shot of the window.

im pretty sure it just doesnt say DB Error: not found...

post everything it return when there is a error!

so you problem is with the php side of things correct!

it might be a "password" problem cos using the mysql console, you dont get prompted for a password but if you try connect using scripting langauge, you have to provide a password!

<<< I want to access a database on my server

this is server on a free website hosting service or are you using IIS on localhost?

im asking this, just to close out that issue and minimise the problem down to PHP script or password issue.

please try this:

enter the mysql by command prompt (where you checked your status...)

i want to set you up using old password styles, just as a test.

when in mysql

try this

mysql> SET PASSWORD FOR
       -> 'root'@'localhost' = OLD_PASSWORD('YOUR_NEW_PASSWORD_HERE');

this is reset all password maps to earlier versions.

so now when you connect using php use this:

<?php
$link = mysql_connect("localhost","root","YOUR_NEW_PASSWORD_HERE");
if (!$link)
     die("Couldn't connect to MySQL");
else
     mysql_query("CREATE DATABASE YOUR_DB_NAME_HERE") or die ("Error: ".mysql_error());
mysql_close($link);
?>


if that dont work, im well confused???

you can try this:

mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%"
          IDENTIFIED BY 'some_password' WITH GRANT OPTION;

Sean

owkey your
 <?php
$link = mysql_connect("localhost","root","YOUR_NEW_PASSWORD_HERE");
if (!$link)
     die("Couldn't connect to MySQL");
else
     mysql_query("CREATE DATABASE YOUR_DB_NAME_HERE") or die ("Error: ".mysql_error());
mysql_close($link);
?>
script works fine (I get a blank page but that's okay because there 's nothing in the database yet :-) ....  WHICH means that the problem is in the old php connection script... so do you have a good script for logging in into a database , adding a table with personal info of the user etc? :-)

Nowp just need a few examples so I can learn it myself... but thanks a lot for your help ;-)

full marks for you
greetz