I need some help in MySql installation ..

2002-08-30 Thread sachin sontakke


From: root

To: [EMAIL PROTECTED]

Subject: I need some help in MySql installation

Description:

I tried to install MySQL,version :- MySQL-3.23.52-1
using RPM which I downloaded from mysql website. I
copied it in my root directory i.e. [root@FireWall2
/root]
My machine name is FireWall2. My OS is Red hat Linux
7.1 with kernel version 2.4.2-2.

From that directory I gave commands 

# rpm -ivh MySQL-3.23.52-1.i386.rpm
# rpm -ivh MySQL-client-3.23.52-1.i386.rpm 
# rpm -ivh MySQL-shared-3.23.52-1.i386.rpm

After doing that it showed me installing MySQL on
machine.

So when I ran following command 

# rpm -q MySQL

I got this
MySQL-3.23.52-1


That means mysql is installed successfully.

What is the step by step procedure for post
Installation configuration of MySql server?

I really do not know that...Could you pls. tell me!
If I have done anything wrong pls. make me aware of
that also.



Following are the few commands I gave and also given
is the corresponding message displayed on the screen.
That could be helpful to you to analyse the case.


1.

[root@FireWall2 init.d]# mysql
ERROR 1045: Access denied for user: 'root@localhost'
(Using password: NO)


2.

[root@FireWall2 bin]# mysqladmin -u root password
'PASSTHEWORD'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost'
(Using password: NO)'


3.

[root@FireWall2 bin]# mysqld --skip-grant-tables
020828 16:08:42  Can't start server: Bind on TCP/IP
port: Address already in use
020828 16:08:42  Do you already have another mysqld
server running on port: 3306 ?
020828 16:08:42  Aborting

020828 16:08:42  mysqld: Shutdown Complete

   
4.

My mysqld daemon is in directory /usr/sbin/

I tried to run it and gave me the following ...

[root@FireWall2 sbin]# mysqld
020830 12:05:22  Can't start server: Bind on TCP/IP
port: Address already in use
020830 12:05:22  Do you already have another mysqld
server running on port: 3306 ?
020830 12:05:22  Aborting

020830 12:05:22  mysqld: Shutdown Complete



Kindly let me know where I am going wrong.

Thanks a lot..


Originator:root
Organization:  CSS Ltd.
Category:  mysql


sachin s.



__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: I need some help in MySql installation ..

2002-08-30 Thread Egor Egorov

sachin,
Friday, August 30, 2002, 10:30:47 AM, you wrote:

ss Description:

[skip]

ss I got this
ss MySQL-3.23.52-1


ss That means mysql is installed successfully.

ss What is the step by step procedure for post
ss Installation configuration of MySql server?

Check chapter 2.4 Post-installation Setup and Testing:
  http://www.mysql.com/doc/en/Post-installation.html

ss I really do not know that...Could you pls. tell me!
ss If I have done anything wrong pls. make me aware of
ss that also.


ss Following are the few commands I gave and also given
ss is the corresponding message displayed on the screen.
ss That could be helpful to you to analyse the case.

ss 1.

ss [root@FireWall2 init.d]# mysql
ss ERROR 1045: Access denied for user: 'root@localhost'
ss (Using password: NO)

ss 2.

ss [root@FireWall2 bin]# mysqladmin -u root password
ss 'PASSTHEWORD'
ss mysqladmin: connect to server at 'localhost' failed
ss error: 'Access denied for user: 'root@localhost'
ss (Using password: NO)'

Did you have installed MySQL server before?

ss 3.

ss [root@FireWall2 bin]# mysqld --skip-grant-tables
ss 020828 16:08:42  Can't start server: Bind on TCP/IP
ss port: Address already in use
ss 020828 16:08:42  Do you already have another mysqld
ss server running on port: 3306 ?
ss 020828 16:08:42  Aborting

ss 020828 16:08:42  mysqld: Shutdown Complete

ss 4.

ss My mysqld daemon is in directory /usr/sbin/

ss I tried to run it and gave me the following ...

ss [root@FireWall2 sbin]# mysqld
ss 020830 12:05:22  Can't start server: Bind on TCP/IP
ss port: Address already in use
ss 020830 12:05:22  Do you already have another mysqld
ss server running on port: 3306 ?
ss 020830 12:05:22  Aborting

ss 020830 12:05:22  mysqld: Shutdown Complete

CHECK if MySQL server is already running with
   ps ax | grep mysqld

If so, take down mySQL server and then start mysqld with
--skip-grant-tables option





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php