Hi me again , regarding my situation i was able to get a responce via >mysql > \r library(eexample db) localhost thus used the select cmd select * from members; and everthings fine .
From the manual it does mention that certian installations allow user to connect as anonymous unamed user to the server running on the localhost thus i need no options . I basically want to enter MySql as the administrator thus utilise the cmd > mysql -u root mysql this all worked fine but i have amended the host table with the sql data staements & sql schema statemets except alter. ie i mean select, inser, update, delete, and also create and drop_priv using the insert into command. Have caused any major problem that can be reversed Cheers Chuckie Amadi Systems Programmer --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php