<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2523" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I think you should try to set a password for
mysql. Then proceed to drop the ser database.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>
<DIV><FONT size=2><FONT face=Arial>1. </FONT><FONT face=Arial>You should set the
sysadmin password. I did it like this:</FONT></FONT></DIV>
<DIV>
<BLOCKQUOTE>
<BLOCKQUOTE><PRE><FONT face=Arial size=2>#mysqladmin -u root password newpassword</FONT></PRE><PRE><FONT face=Arial size=2>Personally, I don't like the way you have to specify the password on the command line.</FONT></PRE></BLOCKQUOTE></BLOCKQUOTE></DIV></FONT></DIV>
<DIV> </DIV>
<DIV> <FONT face=Arial size=2>2. Drop the ser database</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>
# ser_mysql.sh
drop</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I hope it works for you.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>-Emmanuel</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<BLOCKQUOTE>
<BLOCKQUOTE><PRE>----- Original Message ----- </PRE></BLOCKQUOTE></BLOCKQUOTE></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=dknyvice@yahoo.com href="mailto:dknyvice@yahoo.com">dknyvice</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=serhelp@lists.iptel.org
href="mailto:serhelp@lists.iptel.org">serhelp@lists.iptel.org</A> ; <A
title=serusers@lists.iptel.org
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, January 06, 2005 3:56
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Serusers] ser_mysql.sh create
database problem</DIV>
<DIV><BR></DIV>
<DIV>Hi sir,</DIV>
<DIV> </DIV>
<DIV>The problem here is i want to drop the database, and i use mysql default
password that is blank. but it telling me access denied...</DIV>
<DIV>So the question here is how i gonna delete the "ser" database in
order for me to recreate it again.</DIV>
<DIV>I try use reinit and reinstall command but it keep asking me password and
tell me access denied. Can i delete the database using mysql command
prompt?</DIV>
<DIV>My mysql root password is default that is blank.</DIV>
<DIV> </DIV>
<DIV>OS: Linux Fedora Core 2</DIV>
<DIV>SER: Latest 0.8.14</DIV>
<DIV>Mysql: 3.23.58</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV>Wong</DIV>
<P>
<HR SIZE=1>
<FONT face=Arial size=2><A
href="http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.com"><B>Yahoo!
Messenger</B></A> - Communicate instantly..."Ping" your friends today! <A
href="http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.com/download/index.html"><STRONG>Download
Messenger Now</STRONG></A></FONT>
<P>
<HR>
<P></P>_______________________________________________<BR>Serusers mailing
list<BR>serusers@lists.iptel.org<BR>http://lists.iptel.org/mailman/listinfo/serusers<BR></BLOCKQUOTE></BODY></HTML>