Re: SSH tunnel for Mysql

2005-11-20 Thread Lee Zelyck
Are you connecting from a Windows based machine? Are you using a graphical interface? I just helped a coworker do this with Navicat. You just set it up to log into the computer hosting mysql via ssh, this creates the tunnel. Then, you configure navicat to use localhost port 3306 to connect

Upgrading from MySQL Max 3.23 to 4.1.x

2004-12-21 Thread Lee Zelyck
Greetings all, I am currently running mysql-max-3.23.54a-sun-solaris2.9 and would like to upgrade to a 4.1 sparc 64 equivalent. As I'm also running 'depot' on the same machine that has MySQL, I wonder what the easiest way to do this upgrade would be. I presume that it would be to do a

Read-Only DB User

2004-10-10 Thread Lee Zelyck
Hi All, I'm sorry to access such a basic question, but I couldn't find a specific answer to it in the mysql manual pages. The question is, how would someone create a basic read-only user for a single db? I just intend for it to be used by a script to validate data in the db itself.

SOLVED: Read-Only DB User

2004-10-10 Thread Lee Zelyck
Thanks James! The actual command that worked for me was as follows: mysql GRANT SELECT ON db.* TO [EMAIL PROTECTED] IDENTIFIED BY '2user3'; Query OK, 0 rows affected (0.09 sec) I receieved errors while trying to include the 'PASSWORD' option, as that seemed to be wanting a the password in hex

Re: Newbie Can't Add a User to MySQL

2004-03-21 Thread Lee Zelyck
Greetings Michael, Daniel, et al, Good news, I can get in! As evidenced below, however, my php forum script will not authenticate forumuser to insert data. Further, I tried to run a php/mysql authorization test, and still an error. I know this is not a php mailing list, but please find the

Newbie Can't Add a User to MySQL

2004-03-20 Thread Lee Zelyck
Greetings all, I have taken it upon myself to try and learn MySQL management this weekend! No more using root for everything anymore! However, I cannot seem to do anything but create a login. I have tried to build an extrmely simply Forum using MySQL and PHP. I can create the DB and