Queries editor better than standard mysql

2001-02-12 Thread MB

Hi,

I wonder: is there some queries editor better than standard mysql? Maybe
something like dbaccess in Informix.
I use mysqlgui in X, but I'd preffer something in terminal-mode...

--
Mariusz Brzezinski
WBK SA
tel. +48 61 856 53 57
mobile +48 501 623 123



-
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: Need help with Install of MySQL

2001-02-11 Thread MB

> I am new to MySQL and have just installed the MySQL rpm files to my Linux
> box.
>
> I have run "mysql_install_db" with no problems and I have then run
> "safe_mysqld &" this comes up with the messsage
>
> "starting mysql daemon with databses from /var/lib/mysql
>
> mysqld daemon ended"
>
> I assumed that this was corrected and then ran "mysqladmin version" to which
> i recieved the following error message
>
> "can't connect to local mysql server through socket
> /var/lib/mysql/mysql.sock (111)
>
> check that mysql is running and that the socket /var/lib/mysql/mysql.sock
> exists"
>
> I can not find any mysql processes running when I type "ps" and I cannot
> find any sock files anywhere.
>
> What am i doing wrong can somebody please please help.
>

Well I have the same problem and to solve it I run mysql with mysqld
command"mysqld --sock=/var/lib/mysql/mysql.sock -uusername -p" option  from
command line (and it starts).Then I can connect with mysql and check with
mysqladmin.
Maybe someone have better solution of this problem?
Regards

Mariusz Brzezinski
WBK SA
tel. +48 61 856 53 57
mobile +48 501 623 123



-
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: PHP - working with two MySQL serwers

2001-02-08 Thread MB

Anna wrote:

> No.
> As long as you give them different names. :-)
> $connectionLocal=mysql_connect(bleah, bleah, bleah);
> $connectionOther=mysql_connect(bleah, bleah, bleah);
>
> Then in any mysql_query you must, of course, specify
> which connection you are using.
>
> Anna
>

Thanx,
I've already tried (I use Vmware software to "simulate" two linux servers on my
home computer) and it works fine.
Regards
--
Mariusz Brzezinski
WBK SA
tel. +48 61 856 53 57
mobile +48 501 623 123



-
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




PHP - working with two MySQL serwers

2001-02-07 Thread MB

Hi all,
I use replication on MySQL. One of my ideas is to generate HTML pages
using PHP.
Will I have any troubles using PHP and connecting simultaneously to both
servers?
Thanks in advance for any comments.

Mariusz Brzezinski
WBK SA
tel. +48 61 856 53 57
mobile +48 501 623 123



-
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