please advise on mysql memory,users monitoring

2004-12-31 Thread sirisha gnvg
First of all, thanks for the mailing list for giving details about myisamchk.we used them but we got some errors which I have reported in 'myisamchk errors' mail to mysql. At present we are working in mysql 3.23.32 ,windows xp os. Are there any system tables that store mysql related info.(like

mysql memory,users monitoring

2004-12-30 Thread sirisha gnvg
First of all, thanks for the mailing list for giving details about myisamchk.we used them but we got some errors which I have reported in 'myisamchk errors' mail to mysql. At present we are working in mysql 3.23.32 ,windows xp os. Are there any system tables that store mysql related info.(like

mysql memory,users monitoring

2004-12-27 Thread sirisha gnvg
First of all, thanks for the mailing list for giving details about myisamchk. At present we are working in mysql 3.23.32 ,windows xp os. Are there any system tables that store mysql related info.(like memory related issues etc). Are there any other ways to find memory used and free memory

Re: mysql for users

2003-06-07 Thread Nils Valentin
Hi Jude, I think what you want to know is described very nicely in the MySQL documentation. look for GRANT and REVOKE. There are also two reports on devshed which I believe are an excellent source. There is really nothing to add. Print them off read them carefully on your way home and

mysql for users

2003-06-06 Thread jude dashiell
I got mysql working for root and got a password for mysql set by root as well. I got into the tutorial and managed to populate the pet table with the load command and the insert command. The my.cnf file only has user=dashielljt in it and I'd like to know how to arrange things so that users can

[Announcement] for PHP and MySQL 4.1 Users/Testers

2003-02-11 Thread Georg Richter
Hi, The new mysql extension (ext/mysqli) is now in the php-cvs-repository. Please note that you need MySQL Version 4.1 (both server and client library) and that this extension has experimental status. Configuration: --with-mysqli=/path-to-mysql-4.1 -without-mysql If you want to use both

Re: running mysql (mysql users)

2002-12-15 Thread Ryan McDougall
not sure how the windows version works with users. The MySQL root user is just a built in user that is used for, generally, administrative stuff... i.e. making users, backing up DBs, etc ,etc. The built in root user has all of the priviledges it already need but in short it has ALL

RE: running mysql (mysql users)

2002-12-15 Thread Roger Davis
privileges though, so you could not connect from another computer through TCPIP and login to mysql. One thing you need to remember is that Users in mysql, really have no connection to unix/linux users except that if you don't use any username directive (mysql -u uname) it will use the unix/linux username

Re: running mysql (mysql users)

2002-12-15 Thread David T-G
in and fixes things when they get mucked up. % % I do not know how this fits in with the above users (root mysql) but % I usually make myself a mysql superuser, should I do that? Just like you shouldn't casually log in on your machine as root, you shouldn't casually use a root mysql user

Re: running mysql (mysql users)

2002-12-15 Thread tlr7425
accounts with certain limited create capabilities) but also goes in and fixes things when they get mucked up. % % I do not know how this fits in with the above users (root mysql) but % I usually make myself a mysql superuser, should I do that? Just like you shouldn't casually log in on your machine

Re: running mysql (mysql users)

2002-12-15 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ted -- ...and then [EMAIL PROTECTED] said... % % On Sunday, December 15, 2002, at 08:15 AM, David T-G wrote: % % ...and then [EMAIL PROTECTED] said... % % ... % % Most things I've read say to establish a mysql user -I take it this % % is to run the

Re: running mysql (mysql users)

2002-12-15 Thread tlr7425
On Sunday, December 15, 2002, at 10:03 PM, David T-G wrote: % --- % Does anyone know what NetInfo Manager means when it shows a username % (mysql) whose passwd is * (an asterisk)? And how I might incorporate % that user into... whatever I need it for? :) No idea here; sorry. Well, some

running mysql (mysql users)

2002-12-14 Thread tlr7425
, why is a mysql root user needed and what mysql privileges does that user need? I do not know how this fits in with the above users (root mysql) but I usually make myself a mysql superuser, should I do that? Thanks, TR

Re: MySQL tutorials, users passwords, interface.

2002-08-21 Thread Frank Shute
On Wed, Aug 21, 2002 at 03:59:20AM +0100, Donna Robinson wrote: Filter fodder: query, sql On Wednesday 21 August 2002 3:03 am, Nathaniel Mallet wrote: I haven't read Managing and Using MySQL, but I do own (and read cover to cover) MySQL and mSQL. While it's not a bad book, it's

RE: MySQL tutorials, users passwords, interface.

2002-08-20 Thread John Gruber
. John Gruber -Original Message- From: Gavin Alexander [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 6:03 PM To: [EMAIL PROTECTED] Subject: MySQL tutorials, users passwords, interface. HI, I am just starting out with MySQL, using Tomcat as standalone on a Win2000 machine and java

Re: MySQL tutorials, users passwords, interface.

2002-08-20 Thread Donna Robinson
-Original Message- From: Gavin Alexander [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 6:03 PM To: [EMAIL PROTECTED] Subject: MySQL tutorials, users passwords, interface. HI, I am just starting out with MySQL, using Tomcat as standalone on a Win2000 machine and java servlets

Re: MySQL tutorials, users passwords, interface.

2002-08-20 Thread Nathaniel Mallet
To: [EMAIL PROTECTED] Subject: MySQL tutorials, users passwords, interface. HI, I am just starting out with MySQL, using Tomcat as standalone on a Win2000 machine and java servlets. Could anybody: 1) Recomend a good book which covers the basics of MySQL, /or any good tutorials

Re: MySQL tutorials, users passwords, interface.

2002-08-20 Thread Donna Robinson
Filter fodder: query, sql On Wednesday 21 August 2002 3:03 am, Nathaniel Mallet wrote: I haven't read Managing and Using MySQL, but I do own (and read cover to cover) MySQL and mSQL. While it's not a bad book, it's definitely not for anyone wanting to do anything serious. It's about 460 pages

MySQL tutorials, users passwords, interface.

2002-08-19 Thread Gavin Alexander
HI, I am just starting out with MySQL, using Tomcat as standalone on a Win2000 machine and java servlets. Could anybody: 1) Recomend a good book which covers the basics of MySQL, /or any good tutorials on the web? 2) Tell me how to set up usernames and passwords for MySQL. 3) Recomend an easy

Re: MySQL tutorials, users passwords, interface.

2002-08-19 Thread jaydrake
Could anybody: 1) Recomend a good book which covers the basics of MySQL, /or any good tutorials on the web? The mysql documentation is very good, I use http://www.mysql.com/doc/en/index.html as my home page, but you really have to know what to look for in order to find it. It's been so long