[PHP-DB] Need Help in error msg

2010-05-18 Thread nagendra prasad
Hi All, I am getting this error while tried to run a downloaded script in WAMP: [1045] dbconn: mysql_connect: Access denied for user 'root'@'localhost' (using password: YES) Dose anyone know what exactly this means. Best, Guru.

Re: [PHP-DB] Need Help in error msg

2010-05-18 Thread Chaitanya Yanamadala
it means the root user password which u are using is the wrong one.. Chaitanya On Tue, May 18, 2010 at 12:49 PM, nagendra prasad nagendra802...@gmail.comwrote: Hi All, I am getting this error while tried to run a downloaded script in WAMP: [1045] dbconn: mysql_connect: Access denied for

Re: [PHP-DB] Need Help in error msg

2010-05-18 Thread Artur Ejsmont
May also be granted rights to login from '%' which will resolve to any host name except localhost. On 18 May 2010 08:24, Peter Lind peter.e.l...@gmail.com wrote: On 18 May 2010 09:19, nagendra prasad nagendra802...@gmail.com wrote: Hi All, I am getting t... It means that either the password

[PHP-DB] MySQL: Creating a database with

2010-05-18 Thread Alexander Schunk
Hello, i want to create a database with php. A look in the php manual says that you need a special 4.x MySQL version for using mysql_create_db(). I am getting error message: Call to undefined function mysql_create_db(). When is this function defined and in what version of MySQL? yours

Re: [PHP-DB] MySQL: Creating a database with

2010-05-18 Thread Artur Ejsmont
You probably miss the mysql extension or have different one than you are calling. Please call ?php php_info(); ? in script to see what extensions are loaded. if there is some other module supporting mysql just use different way to run sql. otherwise you need to look into php.ini and see if

[PHP-DB] deleting rows with composite primary key

2010-05-18 Thread Systems
Is there a different syntax to the mysql delete statement when the WHERE clause points only to half of the primary key? The structure is as follows: CREATE TABLE IF NOT EXISTS ` table1` ( `id1` int(10) unsigned NOT NULL, `id2` int(10) unsigned NOT NULL, PRIMARY KEY (`id1`,`id2`), KEY

Re: [PHP-DB] deleting rows with composite primary key

2010-05-18 Thread Niel Archer
Is there a different syntax to the mysql delete statement when the WHERE clause points only to half of the primary key? The structure is as follows: CREATE TABLE IF NOT EXISTS ` table1` ( `id1` int(10) unsigned NOT NULL, `id2` int(10) unsigned NOT NULL, PRIMARY KEY (`id1`,`id2`),

Re: [PHP-DB] deleting rows with composite primary key

2010-05-18 Thread Niel Archer
Is there a different syntax to the mysql delete statement when the WHERE clause points only to half of the primary key? The structure is as follows: CREATE TABLE IF NOT EXISTS ` table1` ( `id1` int(10) unsigned NOT NULL, `id2` int(10) unsigned NOT NULL, PRIMARY KEY

Re: [PHP-DB] deleting rows with composite primary key

2010-05-18 Thread Bastien Koert
On Tue, May 18, 2010 at 2:51 PM, Niel Archer n...@chance.now wrote: Is there a different syntax to the mysql delete statement when the WHERE clause points only to half of the primary key? The structure is as follows: CREATE TABLE IF NOT EXISTS ` table1` (   `id1` int(10) unsigned NOT

Re: [PHP-DB] deleting rows with composite primary key

2010-05-18 Thread Niel Archer
On Tue, May 18, 2010 at 2:51 PM, Niel Archer n...@chance.now wrote: Is there a different syntax to the mysql delete statement when the WHERE clause points only to half of the primary key? The structure is as follows: CREATE TABLE IF NOT EXISTS ` table1` (   `id1` int(10)