Re: how to change root password

2006-02-28 Thread Sam Tran
On 2/26/06, Arnel Pastrana [EMAIL PROTECTED] wrote:
 Hi everyone,

 I was installing drupal on my webserver with mysql after i followed
 instructions on how to configure and setup drupal i cant't access the
 root password of my mysql. my password won't work all.

 Any idea how to change my password of root? or is is passible that my
 mysql is currupted?

 Any help?

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Problem installing mysql on Debian linux

2006-02-25 Thread Sam Tran
On 2/25/06, Tselemegkos Grigorios [EMAIL PROTECTED] wrote:
 Hi,

 I'm trying to install mysql 4.0.25 from source on Debian linux without root 
 privileges.
 The problem comes when i execute the configure command.
 I typed:
 configure --prefix /home/grtsel/mysql

 and the output error was:

 checking for FIONREAD in sys/ioctl.h... yes
 checking for TIOCSTAT in sys/ioctl.h... no
 checking if struct dirent has a d_ino member... yes
 checking whether signal handlers are of type void... yes
 checking for tgetent in -lncurses... no
 checking for tgetent in -lcurses... no
 checking for tgetent in -ltermcap... no
 checking for termcap functions library... configure: error: No curses/termcap 
 library found

 I installed ncurses package from source in order to bypass this problem but 
 nothing happend...

 Does anyone know what's going wrong..?
 Please help me...


Gregory,

You need to install the termcap libraries.
What version of Debian are you using? Why don't you install MySQL 5.0.18?

Sam

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Debian and localhost.localdomain

2006-02-25 Thread Sam Tran
On 2/25/06, Yves Goergen [EMAIL PROTECTED] wrote:
 I've been trying to get MySQL to work on Debian 3.1 but it won't let my
 newly created users connect. I added users like [EMAIL PROTECTED]
 and when one tries to connect to the server, it says
 [EMAIL PROTECTED] is not allowed to connect. I suppose
 it's a Debian 3.1 issue since it worked on Debian 3.0. Does anybody know
 how I can get that localdomain out of my computer? Using MySQL 4.0.



What do you have in your /etc/hosts file?

Sam

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



sql-bench and results

2006-02-22 Thread Sam Tran
Hi All,

I installed MySQL 5.0.18 on a Debian Sarge box.

I ran the benchmark suite in the subfolder sql-bench. Now I'd like to
compare my results with other results. According to
http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html
some results are included in sql-bench/Results. But I cannot find this
folder at all. I looked inside the binary installation package and the
source installation package.

Any idea where I can find these results?

Thanks in advance.
Sam

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]