Thanx Navi

but the problem i m facing is when i am starting mysql daeman.

shell> bin/mysqld_safe --user=mysql
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
060201 14:28:32  mysqld ended

the directory /var/run/mysqld doesn't exist. i cudn't find mysqld.pid on my entire system. I hav tried reinstalling different version also but same problem continues. Any suggestion???

Vipin Kumar Singla
UIET, PU, Chandigarh
09888273320


"Singh, Navdeep" <ns_asr@...> wrote:

when u logged in to the mysql> prompt. run the following SQL statement:

 

mysql> grant all on *.* to root@localhost identified by rootpwd;

 

(where *.* means all DBs and all their tables. root is the username, you can create new user here too. localhost is the hostname of your local box, you can set remote client hostname or IP also. rootpwd is the password of that user with your choice)

 

note: when you logout from this session, then onwards you can login only with the new information.

 

thanks,

> navdeep

Vipin Kumar Singla <look_vip@...> wrote:

Hello Everybdy

I hav installed mysql-max-5.1.5-alpha-linux-i686-glibc23.tar.gz with
the following instructions

shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> scripts/mysql_install_db
shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> bin/safe_mysqld --user=mysql &

Everything seemed to work fine.

I want to know now how to start mysql. Where to specify user and
password etc for mysql.

Thanx a lot
Vipin Kumar singla
UIET, PU, Chandigarh
09888273320






Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://in.groups.yahoo.com/group/linux_chandigarh/

<*> To unsubscribe from this group, send an email to:
linux_chandigarh-unsubscribe@...

<*> Your use of Yahoo! Groups is subject to:
http://in.docs.yahoo.com/info/terms/

---

Bring words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.