Getting error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)"

2003-12-30 Thread ads mysql
I am trying to connect to mysql database. getting error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) " Can not shutdown as well as restart. Please help me Thanks for support. - Do you Yahoo!? Free Pop

Not able to connect to mysql by mysql_connect()

2003-12-29 Thread ads mysql
Hi, I am trying to connect mysql through .php script. Following is the php code. ### MYSQL_CONNECT("localhost", "x", "xxx" ) OR DIE("Unable to connect to database"); @mysql_select_db("xxx") or die("Unable to select database"); ### I get following war

Re: How to Uninstall Mysql

2003-12-21 Thread ads mysql
Do I have to uninstall OS to reinstall mysql for my problem.? Please guide me. Thanks for support. ads mysql <[EMAIL PROTECTED]> wrote: Yes I could uninstall mysql with rpm -qa | grep MySQL ("MYSQL" should be in Uppercase. I tried same with lower case earlier) Therefor

RE: load data in file

2003-12-20 Thread ads mysql
Hi, I was looking to solution of same problem as Hans Kind. You have suggested to map network drive. Is it O.K.if SAMBA is ruuning on main server. Or can you guide to Documentation for mapping on Linux. I know it is out of topic but it will help me great. Thanks --- Larry Brown <[EMAIL PROTECTE

Re: How to Uninstall Mysql

2003-12-20 Thread ads mysql
any problems. > > hope it helps, > > -- > MikeBlezien > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Thunder Rain Internet Publishing > Providing Internet Solutions that work! > http://www.thunder-rain.com > Quality Web Hosting > http://www.justlightening.net > MSN: [

Re: How to Uninstall Mysql

2003-12-20 Thread ads mysql
any problems. > > hope it helps, > > -- > MikeBlezien > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Thunder Rain Internet Publishing > Providing Internet Solutions that work! > http://www.thunder-rain.com > Quality Web Hosting > http://www.justlightening.net > MSN: [

Re: How to Uninstall Mysql

2003-12-20 Thread ads mysql
/mysqld --basedir=/ --datadir=/var/lib/mysql 8406 pts/0S 0:00 grep mysqld I want to unistall mysql since thre is no data into it. Please guide me to do so in this situation.. Thanks for support. Victoria Reznichenko <[EMAIL PROTECTED]> wrote: ads mysql wrote: > > I tried a

Re: How to Uninstall Mysql

2003-12-20 Thread ads mysql
/0S 0:00 grep mysqld No response for [EMAIL PROTECTED] root]# rpm -qa | grep mysql. I will prefer to uninstall mysql since it does not have any data. Thanks for support --- Victoria Reznichenko <[EMAIL PROTECTED]> wrote: > ads mysql <[EMAIL PROTECTED]> wrote: >

Re: How to Uninstall Mysql

2003-12-19 Thread ads mysql
mentation but bit difficult to understand for newbe like me. Thanks for support. Victoria Reznichenko <[EMAIL PROTECTED]> wrote: ads mysql wrote: > > I have intstalled mysql rpm. > By mistake user table entries are deleted. Therefore I could not access mysql. > > I want

How to Uninstall Mysql

2003-12-19 Thread ads mysql
I have intstalled mysql rpm. By mistake user table entries are deleted. Therefore I could not access mysql. I want uninstall the same and reinstall it. Please guide me how to do that . Thanks - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing

mysql_connect() problem

2003-12-17 Thread ads mysql
Hi, I am trying to setup network having 1) Linux main server running IPTABLES firewall, squid, dns server. 2) LAN connected to main server. 2) DMZ having apache, mysql and php, mail server connected to main server. User will use php script from remote host to connect to mysql as follows: MYSQL_

mysql_connect() problem

2003-12-17 Thread ads mysql
Hi, I am trying to setup network having 1) Linux main server running IPTABLES firewall, squid, dns server. 2) LAN connected to main server. 2) DMZ having apache, mysql and php, mail server connected to main server. User will use php script from remote host to connect to mysql as follows: MYSQL_CON

Re: Problem creating new user.

2003-12-17 Thread ads mysql
d a grant for 202-63-167-192.exatt.com. and i know its not working, but you really shouldn't post passwords to this list. all posts are archived and that means your password can be read by anyone who google's for help or searches the mysql archive. hth Jeff ads mysql om> cc: [EMAIL

Re: Problem creating new user.

2003-12-17 Thread ads mysql
-p bankaccount Enter password: ERROR 1130: Host '202-63-167-192.exatt.com' is not allowed to connect to this MySQL server. DNS www.networkshastrihall.com is working. Help appreciated. Thanks gerald_clark <[EMAIL PROTECTED]> wrote: ads mysql wrote: >I tried to connect as

Re: Problem creating new user.

2003-12-17 Thread ads mysql
particular Host? Thanks for support. Duncan Hill <[EMAIL PROTECTED]> wrote: On Wednesday 17 December 2003 12:45, ads mysql wrote: > It gives following error :[EMAIL PROTECTED] root]# mysql -u ads11 -p > bankaccount Enter password: (here I enter password 'ads11') >

Problem creating new user.

2003-12-17 Thread ads mysql
Hi, I can create new user with following. mysql>INSERT INTO user (Host,User,Password) VALUES('localhost','ads11',PASSWORD('ads11')); mysql>INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, Create_priv,Drop_priv) VALUES ('localhost','bankaccount','ads11','Y','Y','Y','Y

Re: php installation with mysql support.

2003-12-16 Thread ads mysql
t;[EMAIL PROTECTED]> wrote: On Tuesday 16 December 2003 13:43, ads mysql wrote: > php-4.3.4]# ./configure --with-apxs2=/usr/local/apache2/bin/apxs --with- > mysql=/var/lib/mysql > > It gives error "configure: error: Cannot find MySQL header files under > /var/lib/mysql" >

php installation with mysql support.

2003-12-16 Thread ads mysql
Hi, I am trying to install and configure php with mysql support. I have installed mysql and it works perfectly on the server. On the same server I tried to install php with following configuration : [EMAIL PROTECTED] php-4.3.4]# ./configure --with-apxs2=/usr/local/apache2/bin/apxs --with- mysql

RE: How to create mysql user?

2003-12-16 Thread ads mysql
end with ; or \g. Your MySQL connection id is 84 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> ## Thanks for great support. ads mysql <[EMAIL PROTECTED]> wrote: As advised I tried followin

RE: How to create mysql user?

2003-12-16 Thread ads mysql
D]' (Using password: YES) No luck. Help appreciated. "Duke, Brian" <[EMAIL PROTECTED]> wrote: try this: grant ALL on abc.* to 'abc'@'localhost' identified by 'abc'; >I have created database 'abc' . >mysql> grant ALL on abc.ta

Re: How to create mysql user?

2003-12-16 Thread ads mysql
mysql -u abc -p abc where last abc is ur database name. Nitin - Original Message - From: "ads mysql" To: "Nitin" ; Sent: Tuesday, December 16, 2003 11:51 AM Subject: Re: How to create mysql user? > O K. > I accessed to mysql as root user and tried to created

Re: How to create mysql user?

2003-12-15 Thread ads mysql
ECTED]> wrote: right now, u r trying to connect t omyql with uer abc, not creating it. to create user abc grant on dbname.tablename to 'abc' identified by 'abc'; you can view the list of privileges available on myql website at http://www.mysql.com/doc/en/GRANT.html Enjoy Nit

How to create mysql user?

2003-12-15 Thread ads mysql
Hi, I have installed mysql. As per documentation with user as 'root'. I can create Database, table. I can enter data into table. I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server. by using command : adduser abc -p 'abc' Now I want to create mysql database user 'abc' with comm