mysql password warning
Posted: Mon May 03, 2010 1:59 pm
Hey
I'm not sure if this it the correct place to post this but if not then feel free to move it.
I've created a mysql table to store user names and password and am trying to create a log in page which checks the username and passwords are valid.
I used this sql to create the table "create table users (first_name varchar(25) not null, last_name varchar(25) not null, username varchar(20) unique, password varchar(16);"
However when I try to insert data into the table using "insert into users (first_name, last_name, username, password) values ("jack", "jones", "jack", password("jack"));" it says there is a warning. It's something to do with the password because when you view the table the password is stored as a 15 character string with a "*" at the start.
Does anyone know what I'm doing wrong?
I'm not sure if this it the correct place to post this but if not then feel free to move it.
I've created a mysql table to store user names and password and am trying to create a log in page which checks the username and passwords are valid.
I used this sql to create the table "create table users (first_name varchar(25) not null, last_name varchar(25) not null, username varchar(20) unique, password varchar(16);"
However when I try to insert data into the table using "insert into users (first_name, last_name, username, password) values ("jack", "jones", "jack", password("jack"));" it says there is a warning. It's something to do with the password because when you view the table the password is stored as a 15 character string with a "*" at the start.
Does anyone know what I'm doing wrong?