Re: Uninstall Mysql

> > Before uninstalling MySQL server you can > 1. reset root password, look at: >http://www.mysql.com/doc/R/e/Resetting_permissions.html > > 2. re-create grant tables, look at: >http://www.mysql.com/doc/m/y/mysql_install_db.html > > And about the MySQL server unin

Uninstall Mysql

Can anyone tell me how can I uninstall mysql. I have done it again. I have messed up my permission. I dont know what is is that i'm doing that makes me loose my previleges. I keep getting the access denied error.... Kathy Reyes Live Technology International 2975 Westchester Avenue Suit

Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

if I dont have the mysql.sock running in the temp folder how do I start it??? I tried service mysql start and it did work it give me the same error in the subject line - Original Message - From: "andy thomas" <[EMAIL PROTECTED]> To: "colin o" <[EMAIL PROTECTED]> Cc: "Mike Yrabedra" <[E

mysql datbase backups

I am still a new to mysql. What is the syntax for backing up a table and how do I make it no-lock while doing so. I need the tables to still be able to be written to. I know that this will make my backup a little unaccurate but that doesnt really matter... Kathy Reyes Live Technology

Re: Access denied on use mysql;

PROTECTED]> To: "Kathy Reyes" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 2:55 PM Subject: Re: Access denied on use mysql; > Kathy > I see. > - Original Message - > From: "Kathy Reyes" <[EMAIL PROTECTED]> > To: "alan4100&qu

Re: Access denied on use mysql;

I just gave up, everything that I tried did not work. I killed mysql and then started with safe_mysql --skip-grant-tables then I was able to connect to mysql without an error. But when I tried to Grant all on mysql.* to root@localhost identified by "password"; it gave me the message Unknown C

Re: Cannot access the Database on same Machine

This might help http://ecn.www.ecn.purdue.edu/ECN/Documents/VI/ - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 1:46 PM Subject: Cannot access the Database on same Machine > colin, > Tuesday, March 19, 2002, 11:04:3

Re: Cannot access the Database on same Machine

you can edit this file by going into the directory where the file is located by typing vi filename.Extention. To save changes hit esc key and the :w and then :q to quit. - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002

Re: Date and SQL statement

select * from accounts where duedate<=convert(float,getdate()) - Original Message - From: "Chuck PUP Payne" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 12:31 PM Subject: Date and SQL statement > I need to do a search where I am looking at the table that h

Fw: Access denied on use mysql;

: "alan4100" <[EMAIL PROTECTED]> To: "Kathy Reyes" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 11:59 AM Subject: Re: Access denied on use mysql; > Kathy, > > First please cc to [EMAIL PROTECTED] . There are others who want to read > it. But you sai

Re: Access denied on use mysql;

I've tried everything thats in this email and nothing seems to work for me. I think my situation is a little different because I had access to my database originally but now I cant connect I can sign on as kreyes but I cant sign on as root. I can even sign in as ODBC. I dont know what to do. I hav

Re: Access denied on use mysql;

I've tried everything thats in this email and nothing seems to work for me. I think my situation is a little different because I had access to my database originally but now I cant connect I can sign on as kreyes but I cant sign on as root. I can even sign in as ODBC. I dont know what to do. I hav

Access denied for user

I dont know what I have done now but I have locked myself out of mysql. When I type mysql I get an access violation. At first I thought it might have been something on my end since I am a remote user. But when I attempt to enter mysql from linux box. I get the same access violation... Please someo

MYSQL DATABASE BACKUP

I am trying to backup a table in mysql without locking my tables it this posible - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Benchmark

Hello all its me again Does any one now of any database benchmarking utility that I can use on mysql database??? Kathy Reyes Live Technology International 2975 Westchester Avenue Suite 103 Purchase, NY 10577 Tel: (914) 490-7096 [EMAIL PROTECTED] www.LiveTechnology.com

Default value support function

Can I have a default value call a function in a MYSQL table for example convert(float,getdate()) Kathy Reyes Live Technology International 2975 Westchester Avenue Suite 103 Purchase, NY 10577 Tel: (914) 490-7096 [EMAIL PROTECTED] www.LiveTechnology.com

How do I get the time?

I'm trying time a export process but I cant figure out what the right sql statement. I tried using getdate() but it gives me an error. Any Ideas??? Kathy Reyes Live Technology International 2975 Westchester Avenue Suite 103 Purchase, NY 10577 Tel: (914) 490-7096 [EMAIL PROT