RE: Weird problem with mysql database

2002-01-14 Thread Roger Baklund
* Hamlin Nicholas-qa568 > 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

RE: Weird problem with mysql database

2002-01-14 Thread Hamlin Nicholas-qa568
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

Re: Weird problem with mysql database

2002-01-14 Thread Sinisa Milivojevic
Hamlin Nicholas-qa568 writes: > 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 perso