Printing out tables...tip

2003-02-18 Thread Richard Nagle
Since my original posting, asking how to: print out tables in mysql via out put to a printer. Thanks to all that responded, big thanks to Edward! Here is the tip for all Mac users, running 10.2.x and mysql. goto: http://localhost:631/ ( this program is built-in on 10.2 ) its called CUPS, goto

Print out

2003-02-16 Thread Richard Nagle
What would be the command in mysql for print out this: select * from test3; this prints out the table and show the records on screen now if I wanted to a hard copy.. how would I do this. Thanks- Rick - Before posting, please

load data

2003-02-15 Thread Richard Nagle
where would one put a .txt file to have mysql load it.? what dir. would it have to be in.? Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

New Database,

2003-02-14 Thread Richard Nagle
Okay, I have installed, mySQL, ( all is well ) and now looking to build my first database, is there a comprehensive user manual on how to, say in .pdf format out there ? if not, a on-line link maybe ? Thanks- Richard -

Re: user/root

2003-01-02 Thread Richard Nagle
On Wednesday, January 1, 2003, at 08:06 PM, R. Hannes Niedner wrote: You have a recent installation of mysql then you can just run SET PASSWORD FOR root@localhost=PASSWORD('tko'); and skip the flush privileges. All explained here: http://www.mysql.com/doc/en/Default_privileges.html

Text ?

2003-01-02 Thread Richard Nagle
quick question since I not using a front application to talk with mysql and all would be handle for now threw the terminal window how does one enter in alot of text into a field? I seen alot of db, with single line entries, but none with multi line? eg: db notes: date:1-2-2003 note:Well today,

user/root

2003-01-01 Thread Richard Nagle
Well after 3 times installing mysql, finally got it working (tks to those whom help) now I need to take care of user and root. first root. mysql mysql -u root mysql just want to confirm this is correct before I push enter. mysql update user set password=password('tko') where user='root';

Problems / Reset password / switching to decafe

2002-12-31 Thread Richard Nagle
I been trying to follow the instruction at mysql site to fix mysql, and get it back up and running, so i can add databases. the problem is getting into it (mysql), for some reason the mysqladmin password does not work. so, been forced to kill -9 pid and try the mysql instruction to rest

manual for 3.23.53 pdf?

2002-12-30 Thread Richard Nagle
looking for a pdf manual for mysql 3.23.53 anyone? Thanks- Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

front ends?

2002-12-30 Thread Richard Nagle
what would be the easy to use, gui front end for mySQL 3.23.53 (for Mac OS X ) Thanks Again, Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

server shutdown ? lost password ? (didn't set one)

2002-12-30 Thread Richard Nagle
apparently I can connect to mySQL, as a under privilege user, but can't created a new database, after two days, of getting this far, Now what? So, I did the [MacG4a:~] rnagle% mysql -u root ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) [MacG4a:~] rnagle% Which is

Mac OS X 10.2 ?

2002-12-28 Thread Richard Nagle
just install 3.23.53 for ( Mac OS X 10.2 ) from: www.entropy.ch/software/macosx/mysql all went well, saw prompt mysql type command: show database, saw test, and mysql database did a \q (quit) exit okay, AND THEN ! try to get back into mysql, no luck can see mysqld is still running. how does