I have added some extra fields to the mysql.user table, namely:
full_name VARCHAR(255)
job VARCHAR(255)
location VARCHAR(255)
phone VARCHAR(255)
reminder VARCHAR(255) NOT NULL
ip_addr VARCHAR(255) NOT NULL
I want to store these values for each person that creates a new account on my database.
Th
Sinisa Milivojevic writes:
>
>ALTERing will completely break security and permission systems and
>will even prevent MySQL from proper functioning.
>
Can you give me an example? I'm having no problems with security even after adding
these columns. Users only have access to the dbs and tables th
It should be PrintError (capital 'E').
ie.
---
$dbh = DBI->connect($dsn, $user, $pwd,{PrintError =>
0, RaiseError => 1});
Nicholas
-Original Message-
From: Investor [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 2:43 PM
To: [EMAIL PROTECTED]
Subject: Error with code utilizin
Easier yet, when using DBI::mysql, is:
my $IncrementedID = $dbh->{'mysql_insertid'};
When executed after the INSERT command.
Nicholas
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 9:28 AM
To: 'Ben Curran'; [EMAIL PROTECTED]
Subject:
I can't get table-specific grants to work.
(FIRST: I log in as an administrator and run the following command:)
mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON myDataBase.watch TO '%';
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT * FROM tables_priv;
+--++--++
>On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote:
>> I can't get table-specific grants to work.
>>
>
>
>
>Have you "flush privileges" ?
Yes. That didn't change it.
Nicholas
---
