Try this: Use mysql tables, change or add record in user table. If you add password (and you must) use password('password'). Then flush-previleges from mysqladmin. Also, you must change host and db tables.
Go to www.devshed.com and read "access granted" article. Cheers --- Marius Pana <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > I have installed SuSE Linux 7.3 with Apache, MySQL > and php. Everything is running fine but how come > when I run mysql at the command line it doesnt ask > me for a password? How do I set up a super user? ____________________________________________________________ Do You Yahoo!? &Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&rgr;&egr;&aacgr;&ngr; @yahoo.gr &dgr;&igr;&egr;&uacgr;&thgr;&ugr;&ngr;&sgr;&eegr; &sgr;&agr;&sfgr; &sgr;&tgr;&ogr; http://www.otenet.gr --------------------------------------------------------------------- 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