Recent content by StickyBit

Cheers, I will create the *.bat file and read the manual for grant permissions. Thanks!

I'm running mysql on windows and I would like to connect to the database by typing mysql (only) and not mysql -uroot -proot. This works just fine from my linux and i cant figure out why it wont work on my windows box. I get the following error: C:\>mysql ERROR 1045 (28000): Access denied for...

Thank you folks - using "die(mysql_error());" at the end of the connect function resolved my problem. Access was denied to the user. Thanks folks.

Hello, I'm receiving the following PHP errors from my web application: Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\index.php on line 31 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in...

Hi, I have a large mysql database and would like to see a graphical representation of the database schema i.e. primary keys, foreign keys, related tables. Does anyone know of a good development tool which will display this? Thanks, Stickybit.

Thank you dbtoo2001, I will look at these utilities.

Hi there, Is there a way to identify the table(s) being used by a particular application? Perhaps, a way to log/audit all transactions made against a particular schema…I have an application that uses a database within my environment, and I would like to know which tables are being updated when...

Sorry folks, I guess my question was a little vague. I was trying to script adding passwords to user accounts on a Solaris system via the passwd command. When I ran the script below, the script would echo the passwd to stdin but the passwd command would not read the input – I haven’t seen the...

Exactly! Using a pseudo-terminal fixed my problem. Thank you.

Hi, I have a question regarding terminal I/O via /dev/tty. If a C program reads input directly from /dev/tty (not standard input) is it possible for the shell to redirect input to a C program? In other words, can the shell redirect input to /dev/tty as if the input was coming directly from...

Hello, I have a question regarding terminal I/O via /dev/tty. If a C program reads input directly from /dev/tty (not standard input) is it possible for the shell to redirect input to a C program? In other words, can the shell redirect input to /dev/tty as if the input was coming directly from...

Hello, I have a question regarding terminal I/O via /dev/tty. If a C program reads input directly from /dev/tty (not standard input) is it possible for the shell to redirect input to a C program? In other words, can the shell redirect input to /dev/tty as if the input was coming directly from...

thanks mikevh, Stickybit.

Hey guys, What does the $ at the end of the expression mean? $_ = '0 0 0 360 0.2 12 9.1'; print if (/^\s([\d.]+\s*){7}$/) thanks, stickybit

Paul, I always make it a point to thank/recognise those who have helped me. I got tied up with a couple emergencies yesterday otherwise I would have responded sooner…I apologize. Anyways, Thank you to everyone who helped me yesterday, my understanding of regex is a little better now...