Re: MySQL Connection Problem
Hi, Use this : ps awux | grep mysqld -i On 2/4/06, Casey Rhodes <[EMAIL PROTECTED]> wrote: > > >Casey, > > >in a Terminal window, type > > >ps -ef | grep -i mysql > > >and see if there is a mysqld process actually running and not a zombie > >(defunct). > > >See if you can connect on the localhost. > > >See if the socket exists. > > >I'd bet that one of those three will find your problem. Please let > >us know if this helps. > > >-Sheeri > > > I did this and got the following back: > > ps: illegal option -- f > usage: ps [-aACcehjlmMrSTuvwx] [-O|o fmt] [-p pid] [-t tty] [-U user] >ps [-L] > > > No idea what this means. What now? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- Sincerely, Hadi Rastgou http://www.spreadfirefox.com/?q=affiliates&id=0&t=1";>Get Firefox!
Re: MySQL Connection Problem
>Casey, >in a Terminal window, type >ps -ef | grep -i mysql >and see if there is a mysqld process actually running and not a zombie >(defunct). >See if you can connect on the localhost. >See if the socket exists. >I'd bet that one of those three will find your problem. Please let >us know if this helps. >-Sheeri I did this and got the following back: ps: illegal option -- f usage: ps [-aACcehjlmMrSTuvwx] [-O|o fmt] [-p pid] [-t tty] [-U user] ps [-L] No idea what this means. What now? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Connection Problem
Casey, in a Terminal window, type ps -ef | grep -i mysql and see if there is a mysqld process actually running and not a zombie (defunct). See if you can connect on the localhost. See if the socket exists. I'd bet that one of those three will find your problem. Please let us know if this helps. -Sheeri On 2/2/06, Rhodes, Casey <[EMAIL PROTECTED]> wrote: > When testing my connection via Dreamweave MX, I get the following error > message: > > > > 2002 Can't connect to local MySQL server through socket > '/var/mysql/mysql.sock' (2) > > > > It was suggested to me that the server may not be running, though when I go > to my System Preferences Panel (MacOSX), I have a green light and it says > that it is currently running. > > > > > > --Casey Rhodes > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Connection Problem
do # my_print_defaults mysqld --port=3306 --socket=/var/lib/mysql/mysql.sock --skip-locking --key_buffer=16M --max_allowed_packet=1M --table_cache=64 --sort_buffer_size=512K --net_buffer_length=8K --myisam_sort_buffer_size=8M --server-id=1 To give you the defaults for your mysqld server. It may be listening on the wrong socket for connections. If your mysqld is listening on the same port as DW MX is trying to connect to, then maybe mysql is not running after all. Keith In theory, theory and practice are the same; In practice they are not. On Thu, 2 Feb 2006, Rhodes, Casey wrote: > To: mysql@lists.mysql.com > From: "Rhodes, Casey" <[EMAIL PROTECTED]> > Subject: MySQL Connection Problem > > When testing my connection via Dreamweave MX, I get the > following error message: > > > > 2002 Can't connect to local MySQL server through socket > '/var/mysql/mysql.sock' (2) > > > > It was suggested to me that the server may not be running, > though when I go to my System Preferences Panel (MacOSX), > I have a green light and it says that it is currently > running. > > --Casey Rhodes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: MySQL connection problem
On Thursday 27 March 2003 07:48, rajup at hydbad dot tcs dot co dot in wrote: > I really don't know whether it is a bug in mysql 4.0.12. > I've downloaded 4.0.12 and installed succesfully on my PC(WIN2k with > SPack2). I've changed the bind-address to "localhost" in my.ini and > re-started mysql. > > mysql -h localhost is working fine. > > mysql -h (ip of my machine) or mysql -h (hostname) ends with the following > error: > > ERROR 2003: Can't connect to MySQL server on '172.16.3.106' (10061) > > Earlier I had mysql 3.23.48 on the same machine. It used to work fine for > all the above three commands. > > Could you please help me out??? Sure, because you have binded MySQL to localhost (127.0.0.1) which is definitely not "172.16.3.106". -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL connection problem
localhost is 127.0.0.1 in most systems unless you modify your hosts file, since 172.16.3.106 is not localhost, connecting thru that localhost will definitely not work for it's not localhost =) it's not a bug i believe. another thing, if you grant a user with a host localhost, and you place a mysql -ublah -p -h172.16.3.106 it wouldn't also work, you need to add a user with that @172.16.3.106 address for it to be allowed to access mysql, well that's with grants and a fairly different story. Respectfully yours, Sherwin T. Ang Systems Administrator Tridel Technologies Incorporated 7F Hanston Building Emerald Avenue, Ortigas Center Pasig City 1605 Philippines Phone: 6345140 Local 1024 Web: http://www.tridel.net Email: [EMAIL PROTECTED] sql, query - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 27, 2003 1:48 PM Subject: MySQL connection problem > Hi, > I really don't know whether it is a bug in mysql 4.0.12. > I've downloaded 4.0.12 and installed succesfully on my PC(WIN2k with > SPack2). I've changed the bind-address to "localhost" in my.ini and > re-started mysql. > > mysql -h localhost is working fine. > > mysql -h (ip of my machine) or mysql -h (hostname) ends with the following > error: > > ERROR 2003: Can't connect to MySQL server on '172.16.3.106' (10061) > > Earlier I had mysql 3.23.48 on the same machine. It used to work fine for > all the above three commands. > > Could you please help me out??? > > Thanx in adv, > RK > * * * The information contained in this message is legally privileged and > confidential information intended only for the use of the addressed > individual or entity indicated in this message (or responsible for > delivery of the message to such person). It must not be read, copied, > disclosed, distributed or used by any person other than the addressee. > Unauthorised use, disclosure or copying is strictly prohibited and may be > unlawful. Opinions, conclusions and other information on this message that > do not relate to the official business of any of the constituent companies > of the TATA CONSULTANCY SERVICES shall be understood as neither given nor > endorsed by the Group. If you have received this message in error, you > should destroy this message and kindly notify the sender by e-mail. Thank > you. * * * > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mySQL connection problem!!!
Hi Todd Thanks.. I checked and did like.. from root mysqladmin shutdown and then again.. restarted the server from.. /etc/rc.d/init.d/mysqld start but of no use! --- As suggested by: Gerald Clark <[EMAIL PROTECTED]> FROM babul USER.. i can not go to /var/lib/mysql where all the databse directries/files are created.. so I hv changed teh dir/file perms of of /var/lib/mysql/*.* to 777!! and now its working.. when i execute $mysql -u nedfi -pnedfi2001 nedfi I get the mysql> prompt!! lets see if I can do other works.. Thanks Gerald Clark !! for ur suggestion.. any idea or comments? Babul --- Todd Williamsen <[EMAIL PROTECTED]> wrote: > I think I read somewhere about this issue. I think > it had to do with > multiple mySQL servers running concurrently. > > See if there is multiple servers running using the > ps command. If so, > then kill one of them. Also, when adding a user, do > you select a > database first before adding a user? > > -Original Message- > From: b g [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 13, 2002 2:35 AM > To: Sherwin T. Ang > Cc: [EMAIL PROTECTED] > Subject: Re: mySQL connection problem!!! > > > Hello Sherwin, > > Thanks for ur prompt reply. > > Yes, I have gone thru the mySQL manual chapter that > you have mentioned.. > > But what I think the problem is somewhere else.. > > when I try to execute the command 'mysql' (when I > log > in as user 'babul') on command line, I get the > following error: > > ERROR 2002: Can't conect to local MySQL server > through > socket '/var/lib/mysql/mysql.sock' (111) > > It seems that the mySQL server is not running on the > system... where as when I in superuser mode or login > thru mysql user, I get just the "mysql>" prompt..!! > > This is my first time with mySQL.. I m actually > trying > to restore a web database into my loca machine.. > then > update it locally and later withh restore it to the > web server.. > > Babul > > > > > > > - > 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 > __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.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: mySQL connection problem!!!
I think I read somewhere about this issue. I think it had to do with multiple mySQL servers running concurrently. See if there is multiple servers running using the ps command. If so, then kill one of them. Also, when adding a user, do you select a database first before adding a user? -Original Message- From: b g [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 2:35 AM To: Sherwin T. Ang Cc: [EMAIL PROTECTED] Subject: Re: mySQL connection problem!!! Hello Sherwin, Thanks for ur prompt reply. Yes, I have gone thru the mySQL manual chapter that you have mentioned.. But what I think the problem is somewhere else.. when I try to execute the command 'mysql' (when I log in as user 'babul') on command line, I get the following error: ERROR 2002: Can't conect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) It seems that the mySQL server is not running on the system... where as when I in superuser mode or login thru mysql user, I get just the "mysql>" prompt..!! This is my first time with mySQL.. I m actually trying to restore a web database into my loca machine.. then update it locally and later withh restore it to the web server.. Babul - 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: mySQL connection problem
On Wed, 2002-03-13 at 08:08, b g wrote: > when I m in root or mysql USER login.. then I can > login to mySQL server.. its fine.. > but other than 'root' and 'mysql', i can not connect > to the database server.. With which user are you trying to connect ? Did you grant permissions to that user ? Be more specific. > thats why I am not able to run any web based database > connection.. i get could not connect to database.. > > can u pls explain wht to do now? > > I hv created one mysql user using this: > > $ su > passwd: > shell> mysql --user=root mysql > mysql> GRANT ALL PRIVILEGES ON *.* TO babul@localhost > -> IDENTIFIED BY 'babul123' WITH GRANT OPTION; > -> \q > $ > > then i am able to connect using the database > user/pass .. that too when i was in super-user mode.. > else frm other users, i m not able > to conenct.. pls help.. > > the mysqld is running! > > Babul > in India.. > -- dsoares (sql) - 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: mySQL connection problem!!!
Hello Sherwin, Thanks for ur prompt reply. Yes, I have gone thru the mySQL manual chapter that you have mentioned.. But what I think the problem is somewhere else.. when I try to execute the command 'mysql' (when I log in as user 'babul') on command line, I get the following error: ERROR 2002: Can't conect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) It seems that the mySQL server is not running on the system... where as when I in superuser mode or login thru mysql user, I get just the "mysql>" prompt..!! This is my first time with mySQL.. I m actually trying to restore a web database into my loca machine.. then update it locally and later withh restore it to the web server.. Babul --- "Sherwin T. Ang" <[EMAIL PROTECTED]> wrote: > hello, > > regardless on what system user you are, root or > ordinary system user, you > can still connect to the mysql server with MYSQL > ROOT privileges as long as > you know the password of root. Because a SYSTEM ROOT > is different from MYSQL > ROOT user. > > well in the case of your problem, you should read > the GRANT and REVOKE > syntax in the manual to make it clearer. > > http://www.mysql.com/doc/G/R/GRANT.html > > Regards, > > Sherwin T. Ang > Web Technical Administrator / Programmer > Alchemy Solutions > http://www.alchemy.com.ph > Creative. Technology. > > Tridel Technologies, Inc. > 7th Floor Hanston Building > Emerald Ave., Ortigas Center > Pasig City > Philippines > > Tel: (632) 634-5141/ (632) 634-5140 Local 1040 > Fax: (632) 634-5139 > > - Original Message - > From: "b g" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, March 12, 2002 11:38 PM > Subject: mySQL connection problem!!! > > > > Hello, > > > > I m ina great problem.. > > > > I am not able to conenct to mySQL server.. > > the problem is like.. when I m in root or mysql > USER > > login.. then I can login to mySQL server.. its > fine.. > > but other than 'root' and 'mysql', i can not > connect > > to the database server.. > > > > thats why I am not able to run any web based > database > > connection.. > > > > can u pls explain wht to do now? > > > > I hv created one mysql user using this: > > > > $ su > > passwd: > > $ mysql -u root mysql > > mysql> grant all priviliges on *.* to > user@localhost > > with grant option; > > mysql>\q > > $ > > > > and then i am able to connect.. that too when i > was > > in superuser mode.. else frm other users, i m not > able > > to conenct.. pls help.. > > > > the mysqld is running! > > > > Babul > > in India.. > > > > > > > > __ > > Do You Yahoo!? > > Try FREE Yahoo! Mail - the world's greatest free > email! > > http://mail.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 > > > > > > __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.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: RE: RE: RE: Mysql connection problem
Hi Gary, Finally I can access the server. You are my hero. I am new to mysql. It takes me a month to try it. Thank you very very much! Cindy >>> <[EMAIL PROTECTED]> 01/08 11:14 AM >>> from your bindir type: ./mysql -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 12:07 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: RE: Mysql connection problem Hi Simon, I appreicate your help. Our server is a Solaris 5.6 server. After I cd to the mysql bin directory bindir=/usr/local/bin and connect to mysql server by using mysql or mysqladmin, the server shows me mysql not found and mysqladmin not found. Can you give my some clue? You have much much more experience than me. I am frustrated and can not figure it out. mysql.server file shows: path=/sbin: /usr/sbin:/usr/bin basedir=/usr/local bindir=/usr/local/bin datadir=/usr/local/var pid-file=/usr/local/var/mysqld.pid log-file=/usr/local/var/mysqld.log Cindy >>> Simon Green <[EMAIL PROTECTED]> 01/08 1:26 AM >>> Ok. Bring down server: Find the process by useing ps command. Then use the kill command and then send a TERM signal to the server to see if it will respond by shutting down normally. Check tables using myisamchk and isamchk. Restart server with --skip-grant-tables option. Set new root password. Now restart the server with mysqladmin and flush-privileges. Hope this helps Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 18:17 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: Mysql connection problem Hi Simon, Thanks for your reply. Can you tell me how to do it? I tried, but it shows me the error: "mysql not found". How can I find mysql server? Cindy >>> Simon Green <[EMAIL PROTECTED]> 01/07 10:05 AM >>> No but you can start MySQL with out grant tables. See on line manual and don't know password. Or ./mysql --help Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 17:48 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Mysql connection problem Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can I do it? Your answer will be appreciated! Cindy - 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 - 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 - 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: Mysql connection problem
The server is not telling you that mysql is not found. The shell is telling you that mysql is not found because the the current directory is not included in the PATH searched by the shell. try ./mysql or /usr/local/bin/mysql. Cindy Yu wrote: >Hi Simon, > >I appreicate your help. > >Our server is a Solaris 5.6 server. After I cd to the mysql bin directory >bindir=/usr/local/bin and connect to mysql server by using mysql or mysqladmin, the >server shows me mysql not found and mysqladmin not found. Can you give my some clue? >You have much much more experience than me. I am frustrated and can not figure it out. > >mysql.server file shows: > >path=/sbin: /usr/sbin:/usr/bin >basedir=/usr/local >bindir=/usr/local/bin >datadir=/usr/local/var >pid-file=/usr/local/var/mysqld.pid >log-file=/usr/local/var/mysqld.log > >Cindy > >>>>Simon Green <[EMAIL PROTECTED]> 01/08 1:26 AM >>> >>>> >Ok. >Bring down server: >Find the process by useing ps command. >Then use the kill command and then send a TERM signal to the server to see >if it will respond by shutting down normally. >Check tables using myisamchk and isamchk. >Restart server with --skip-grant-tables option. >Set new root password. >Now restart the server with mysqladmin and flush-privileges. > >Hope this helps > >Simon > >-Original Message- >From: Cindy Yu [mailto:[EMAIL PROTECTED]] >Sent: 07 January 2002 18:17 >To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; >[EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Subject: Re: RE: Mysql connection problem > > >Hi Simon, > >Thanks for your reply. Can you tell me how to do it? I tried, but it shows >me the error: > >"mysql not found". How can I find mysql server? > >Cindy > >>>>Simon Green <[EMAIL PROTECTED]> 01/07 10:05 AM >>> >>>> >No but you can start MySQL with out grant tables. >See on line manual and don't know password. >Or ./mysql --help > >Simon > >-Original Message- >From: Cindy Yu [mailto:[EMAIL PROTECTED]] >Sent: 07 January 2002 17:48 >To: [EMAIL PROTECTED]; [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Subject: Mysql connection problem > > >Hello, > > >I have a question for you. I have a Solaris 5.6 server running Mysql. It is >our company' website. I just know the server's root password and I don't >know mysql database user name and password. Is it possible to login to Mysql >database by using the server root and its password? How can I do it? > >Your answer will be appreciated! > >Cindy > > > >- >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 > > >- >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 > > - 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: RE: RE: Mysql connection problem
from your bindir type: ./mysql -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 12:07 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: RE: Mysql connection problem Hi Simon, I appreicate your help. Our server is a Solaris 5.6 server. After I cd to the mysql bin directory bindir=/usr/local/bin and connect to mysql server by using mysql or mysqladmin, the server shows me mysql not found and mysqladmin not found. Can you give my some clue? You have much much more experience than me. I am frustrated and can not figure it out. mysql.server file shows: path=/sbin: /usr/sbin:/usr/bin basedir=/usr/local bindir=/usr/local/bin datadir=/usr/local/var pid-file=/usr/local/var/mysqld.pid log-file=/usr/local/var/mysqld.log Cindy >>> Simon Green <[EMAIL PROTECTED]> 01/08 1:26 AM >>> Ok. Bring down server: Find the process by useing ps command. Then use the kill command and then send a TERM signal to the server to see if it will respond by shutting down normally. Check tables using myisamchk and isamchk. Restart server with --skip-grant-tables option. Set new root password. Now restart the server with mysqladmin and flush-privileges. Hope this helps Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 18:17 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: Mysql connection problem Hi Simon, Thanks for your reply. Can you tell me how to do it? I tried, but it shows me the error: "mysql not found". How can I find mysql server? Cindy >>> Simon Green <[EMAIL PROTECTED]> 01/07 10:05 AM >>> No but you can start MySQL with out grant tables. See on line manual and don't know password. Or ./mysql --help Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 17:48 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Mysql connection problem Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can I do it? Your answer will be appreciated! Cindy - 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 - 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 - 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: RE: RE: Mysql connection problem
Hi Simon, I appreicate your help. Our server is a Solaris 5.6 server. After I cd to the mysql bin directory bindir=/usr/local/bin and connect to mysql server by using mysql or mysqladmin, the server shows me mysql not found and mysqladmin not found. Can you give my some clue? You have much much more experience than me. I am frustrated and can not figure it out. mysql.server file shows: path=/sbin: /usr/sbin:/usr/bin basedir=/usr/local bindir=/usr/local/bin datadir=/usr/local/var pid-file=/usr/local/var/mysqld.pid log-file=/usr/local/var/mysqld.log Cindy >>> Simon Green <[EMAIL PROTECTED]> 01/08 1:26 AM >>> Ok. Bring down server: Find the process by useing ps command. Then use the kill command and then send a TERM signal to the server to see if it will respond by shutting down normally. Check tables using myisamchk and isamchk. Restart server with --skip-grant-tables option. Set new root password. Now restart the server with mysqladmin and flush-privileges. Hope this helps Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 18:17 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: Mysql connection problem Hi Simon, Thanks for your reply. Can you tell me how to do it? I tried, but it shows me the error: "mysql not found". How can I find mysql server? Cindy >>> Simon Green <[EMAIL PROTECTED]> 01/07 10:05 AM >>> No but you can start MySQL with out grant tables. See on line manual and don't know password. Or ./mysql --help Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 17:48 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Mysql connection problem Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can I do it? Your answer will be appreciated! Cindy - 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 - 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: RE: Mysql connection problem
Ok. Bring down server: Find the process by useing ps command. Then use the kill command and then send a TERM signal to the server to see if it will respond by shutting down normally. Check tables using myisamchk and isamchk. Restart server with --skip-grant-tables option. Set new root password. Now restart the server with mysqladmin and flush-privileges. Hope this helps Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 18:17 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: Mysql connection problem Hi Simon, Thanks for your reply. Can you tell me how to do it? I tried, but it shows me the error: "mysql not found". How can I find mysql server? Cindy >>> Simon Green <[EMAIL PROTECTED]> 01/07 10:05 AM >>> No but you can start MySQL with out grant tables. See on line manual and don't know password. Or ./mysql --help Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 17:48 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Mysql connection problem Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can I do it? Your answer will be appreciated! Cindy - 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 - 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: RE: Mysql connection problem
Hi Simon, Thanks for your reply. Can you tell me how to do it? I tried, but it shows me the error: "mysql not found". How can I find mysql server? Cindy >>> Simon Green <[EMAIL PROTECTED]> 01/07 10:05 AM >>> No but you can start MySQL with out grant tables. See on line manual and don't know password. Or ./mysql --help Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 17:48 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Mysql connection problem Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can I do it? Your answer will be appreciated! Cindy - 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: Mysql connection problem
No but you can start MySQL with out grant tables. See on line manual and don't know password. Or ./mysql --help Simon -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 17:48 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Mysql connection problem Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can I do it? Your answer will be appreciated! Cindy - 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: :mysql - connection problem
Download and install http://www.perl.com/CPAN-local/authors/id/J/JW/JWIED/DBD-mysql-2.0901.tar.gz > Hi, > > I am a newbie and hope someone can she light on why I can't get the > DBD::mysql connection working in my perl script. The script is a test one > and very simple. > > I have the mysql daemon running and mysqladmin works, and DBI is installed > too. I went through the installation process for DBD and have also placed > the /usr/local/mysql path reference in the environment. These are the > errors below: > > --- > Can't locate DBD/mysql.pm in @INC (@INC contains: > /opt/perl5/lib/5.6.0/PA-RISC1.1 /opt/perl5/lib/5.6.0 > /opt/perl5/lib/site_perl/5.6.0/PA-RISC1.1 /opt/perl5/lib/site_perl/5.6.0 > /opt/perl5/lib/site_perl .) at create_table.pl line 8. > BEGIN failed--compilation aborted at create_table.pl line 8. > --- - 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
