I am currently using Mysql version 1.4 for Windows 2000, and I cannot connect to my database via phpMyAdmin.
I have run mysql and was able to type Use SAMDB<--my database and it worked. But when I type the following grant all to theedge2k@flatman identified by 'mysql password'; It comes back and says the following ERROR 1064 you have an error in your SQL syntax near to theedge2k@flatman identified by the 'thepool'; My setup as follows Box 1 - Apache/PHP installed Box 2 - Sam 2 and MYSQL installed (Sam 2 dynamically creates web pages from here but the actual file is created on Box 1 in htdocs folder. Box 3 - PHPMyAdmin installed and where I do all work from on my LAN. Box 1 is never touched by hands (keyboard disabled to prevent me or any from screwing it up. That is the same with my box 2 where Sam 2 installed (very cautious). [mysqld] basedir=D:/mysql #bind-address=192.168.1.3 datadir=D:/mysql/data #language=D:/mysql/share/your language directory #slow query log#= #tmpdir#= port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=D:/mysql/bin/mysqld-nt.exe Any ideas or help would be greatly appreciated "Gman" Local Troublemaker Extraordinaire Owner: The Edge Internet Radio Station "The Internet Rock Station" ICQ#: 136383819 Hotmail: [EMAIL PROTECTED] Yahoo: [EMAIL PROTECTED] Aim: [EMAIL PROTECTED] Dude! Right now you could be getting your ass rocked on The Edge. So what the hell are you waiting for? Get Rocked on The Edge! The Internet Rock Station! Fear This! --------------------------------------------------------------------- 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
