Re: Unable to connect to mysql with phpmyadmin

[Michael Stassen]

Marvin Cummings wrote:

I finally managed to get this working. It turns out I was using the wrong
password for the root account and once I remembered what the correct
password was I was able to log in via phpMyAdmin. 
I'm using MySQL 5.0alpha with php4.3.4. and phpMyAdmin ver2.5.6.

Now I want to switch the 'auth_type' to 'HTTP'. I change it to HTTP and
remove the password. I try to log in as root, localhost\root and
[EMAIL PROTECTED] and get a "You are not authorized to view this page" error.
What do I need to do to change the auth_type? 

Thanks again for the help. 
Did you set up the controluser?  phpmyadmin needs to have a user and 
password it can use to access mysql to read the user table to compare the 
username/password you supply with auth_type HTTP against what's set up in 
the db.  You have to create the controluser in mysql, then edit your 
config.inc.php to set the controluser variables accordingly.  See the 
phpmyadmin manual  for the details.

Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Need help creating table using phpMyAdmin

[Michael Stassen]

Marvin Cummings wrote:

Sorry for this easy question but I'm kind of a newbie and I'm wondering if
someone could assist me with creating a new table for a postnuke module? I
need to copy the following content into a table I create named nuke_zc_ads: 
(
`ad_id` smallint(5) unsigned NOT NULL auto_increment,
`cat_id` smallint(5) unsigned NOT NULL default '0',
`user_name` varchar(20) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`price` text NOT NULL,
`condition` varchar(10) NOT NULL default '',
`city` varchar(20) NOT NULL default '',
`state` varchar(20) NOT NULL default '',
`country` varchar(20) NOT NULL default '',
`lastup_date` int(11) NOT NULL default '0',
`subject` text NOT NULL,
`descript` text NOT NULL,
`url` text NOT NULL,
`views` int(11) NOT NULL default '0',
`paypal` char(3) NOT NULL default 'No',
`add_date` int(11) NOT NULL default '0',
`exp_date` int(11) NOT NULL default '0',
PRIMARY KEY (`ad_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

I see where to create the table but I'm not sure about the number of fields
to add. My instincts are telling me I need 18 fields but I just need to
confirm. 
17 would do, so long as you check the "primary" button on the first one 
(ad_id), but this would be much simpler to do with the mysql client. 
Connect with

  mysql -u root -p nameofdb

replacing "nameofdb" with whatever you've named the database this table will 
belong to.  After you've supplied the password and gotten in, enter

  CREATE TABLE nuke_zc_ads
  (
  `ad_id` smallint(5) unsigned NOT NULL auto_increment,
   .
   .
   .
  ) TYPE=MyISAM AUTO_INCREMENT=1 ;
In other words, copy what you have above and paste it in after entering the 
"CREATE TABLE" line.  That's it -- you're done -- table created.  You could 
do it with phpmyadmin, but it'll take awhile filling in all those boxes.

Any responses are appreciated.
Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Need help creating table using phpMyAdmin

[Marvin Cummings]

Sorry for this easy question but I'm kind of a newbie and I'm wondering if
someone could assist me with creating a new table for a postnuke module? I
need to copy the following content into a table I create named nuke_zc_ads: 

 

(
`ad_id` smallint(5) unsigned NOT NULL auto_increment,
`cat_id` smallint(5) unsigned NOT NULL default '0',
`user_name` varchar(20) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`price` text NOT NULL,
`condition` varchar(10) NOT NULL default '',
`city` varchar(20) NOT NULL default '',
`state` varchar(20) NOT NULL default '',
`country` varchar(20) NOT NULL default '',
`lastup_date` int(11) NOT NULL default '0',
`subject` text NOT NULL,
`descript` text NOT NULL,
`url` text NOT NULL,
`views` int(11) NOT NULL default '0',
`paypal` char(3) NOT NULL default 'No',
`add_date` int(11) NOT NULL default '0',
`exp_date` int(11) NOT NULL default '0',
PRIMARY KEY (`ad_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

 

 

I see where to create the table but I'm not sure about the number of fields
to add. My instincts are telling me I need 18 fields but I just need to
confirm. 

 

Any responses are appreciated.

mysqld crash, got following

[Paizulaev Abdula]

InnoDB: Error: record field 3 len 4294967207
Heap no too big 5888 93
Error in page 117145 in index PRIMARY
Record has 654 fields, should have 24
InnoDB: record RECORD: info bits 0 0:
040405  8:36:56  InnoDB: Assertion failure in thread 9226 in file
../include/page0page.ic line 482
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail

key_buffer_size=8388600
record_buffer=131072
sort_buffer=2097144
max_used_connections=0
max_connections=16
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 43007 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation

Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Stack range sanity check OK, backtrace follows:
0x80c9d62
0x40027f75
0x819d1bc
0x819db86
0x81a3168
0x8171a83
0x811a431
0x811fcb4
0x812299a
0x80d1793
0x80d390f
0x80cfc3e
0x80cf0e4
Stack trace seems successful - bottom reached
Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x85eb3a8 = CHECK TABLE `radacct`  EXTENDED
thd->thread_id=1

Successfully dumped variables, if you ran with --log, take a look at the
details of what thread 1 did to cause the crash.  In some cases of really
bad corruption, the values shown above may be invalid

The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains
information that should help you find out what is causing the crash

Number of processes running now: 0
040405 08:36:56  mysqld restarted
040405  8:36:58  InnoDB: Started

---
Abdulla Paizulaev,
Electrosvyaz close corp.,
Makhachkala, Daghestan,
[EMAIL PROTECTED], icq 342000,
+78722608210, +79034984708


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Unable to connect to mysql with phpmyadmin

[Marvin Cummings]

I finally managed to get this working. It turns out I was using the wrong
password for the root account and once I remembered what the correct
password was I was able to log in via phpMyAdmin. 
I'm using MySQL 5.0alpha with php4.3.4. and phpMyAdmin ver2.5.6.

Now I want to switch the 'auth_type' to 'HTTP'. I change it to HTTP and
remove the password. I try to log in as root, localhost\root and
[EMAIL PROTECTED] and get a "You are not authorized to view this page" error.
What do I need to do to change the auth_type? 

Thanks again for the help. 

-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED] 
Sent: Sunday, April 04, 2004 2:13 PM
To: Marvin Cummings
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Unable to connect to mysql with phpmyadmin


Marvin Cummings wrote:

> I've tried it both ways using the default root and no password and root
with
> my assigned password. Either way returns an error. Here's a part of my
> config.inc.php file:
> 
> // The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use
> $cfg['Servers'][0].
> // You can disable a server config entry by setting host to ''.
> $i++;
> $cfg['Servers'][$i]['host']  = 'localhost'; // MySQL hostname or
IP
> address

> $cfg['Servers'][$i]['auth_type'] = 'HTTP';// Authentication method
> (config, http or cookie based)?
> $cfg['Servers'][$i]['user']  = 'root';  // MySQL user
> $cfg['Servers'][$i]['password']  = '';  // MySQL password
(only
> needed
> // with 'config'
> auth_type)

> Again I've tried it with 'config' and 'HTTP' as the 'auth_type' with and
> without a password. I'm sure I'm missing something. 
> 
>  Thanks again

I know you must be frustrated, but [EMAIL PROTECTED] either has a password or 
it doesn't -- there's no sense trying the other.  From your description, I 
take it that root does have a password.

First, verify that the password works.  Try

   mysql -u root -p

at the command line, and enter the password when prompted.  If that works, 
then you know that you have the correct user-password combination for mysql.

  Be sure to tell us that this worked (or didn't) in your next post. 
Assuming it worked, you'll see something like, "Your MySQL connection id is 
13 to server version: 4.0.17" on the second line.  Make note of the server 
version number and tell us what it is.

The next step is to see if we can get PHP/phpmyadmin to talk to mysql.  The 
simplest (Note, I did not say best.) way is to use config.  So, in your 
config.inc.php, set auth_type to config, and password to your mysql root 
password.  This should work, but from what you've said, it won't.  In your 
next post, tell us what error message you get in this case, particularly 
whether it says "YES" or "NO".

Finally, tell us some more about your setup.  I imagine you have the latest 
phpmyadmin, as you just set it up.  What about PHP?  We need to know 2 
things: which version of PHP you have, and which version of MySQL it was 
built against.  If I recall correctly, PHP's built-in MySQL support is 
version 3.23.49, which is rather old.  MySQL's authentication mechanism has 
been changed in 4.1 and later.  If you don't know the answers to those 2 
questions, make a file in your webspace (same directory as config.inc.php 
would do) with

   

as the contents.  Pull that up in your web brpwser to see a ton of info. 
The version of PHP will be right at the top, and MySQL support info will be 
down in the mysql section.  Tell us what it says for "Client API version".

I know I'm asking you to do a couple of things you've already done, but it's

difficult to troubleshoot when we can't be sure exactly which error message 
went with which attempt.  My hope is that with specific info, we'll be able 
to narrow down where the problem lies.

Michael

P.S.  Note that using auth_type=config in your config.inc.php along with 
your mysql root password means that anyone who can access phpmyadmin will 
have root access to mysql.  So, once you get this working, you will need to 
either protect access to phpmyadmin or switch to another auth_type.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

I need support

I can only connect to mysql with the username root and no password I have the ini file 
configured with a username and password but I can't connect with them.
I am using win xp and winmysqladmin ver. 1.4
I cant genarate a report because it says I must be connected first.
On the environment tab myodbc window says not found driver 3.51 not found.

Re: Complete confusion

[Ligaya Turmelle]

If your looking for just sql tutorials check out
http://www.geekgirls.com/menu_databases.htm which is tutorials for the
basics of database and databases design or go here http://www.sqlcourse.com/
for a tutorial on basic SQL or here http://sqlcourse2.com/ for a look at
some of the more advances stuff.

Hope that helps.

Respectfully,
Ligaya Turmelle


""SeeNewIdeas"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi Rhino,

What I was referring to was the mySQL statements.  I'm working on redoing
the form so there is no problem there, it is how to use the statements to
code what needs to be done.

I know everybody has to begin somewhere when they're learning how to do this
I'm just looking for the best tutorial perhaps that has sample coding so
that I can follow along and adapt it to what I need.

Thanks
dawson





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Complete confusion

[SeeNewIdeas]

Hi Rhino,

What I was referring to was the mySQL statements.  I'm working on redoing the form so 
there is no problem there, it is how to use the statements to code what needs to be 
done.

I know everybody has to begin somewhere when they're learning how to do this I'm just 
looking for the best tutorial perhaps that has sample coding so that I can follow 
along and adapt it to what I need.

Thanks
dawson

Re: Complete confusion

[Rhino]

Dawson,

When you say "coding" do you mean programming or are you talking about SQL
that you can run from the command line? You *can* create tables, load them,
query them, etc. from the command line with just the MySQL/sql statements
without having to know how to do programming. However, if you plan to
display your database data in applications, web pages, etc., you'll probably
need to do some programming.

If you plan to do some programming, what language do you plan to use? Java?
Php? Perl? C? something else? There's no point in sending you a URL for Java
programming if you plan to code in Perl or whatever

Rhino



- Original Message - 
From: "SeeNewIdeas" <[EMAIL PROTECTED]>
To: < [EMAIL PROTECTED]>
Sent: Sunday, April 04, 2004 3:44 PM
Subject: Complete confusion


Where is the best tutorial that will show me opening coding and possible
other coding to get info out of the database, etc.

I guess you might say a real newbie tutorial.

Thanks
dawson


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Complete confusion

[SeeNewIdeas]

Where is the best tutorial that will show me opening coding and possible other coding 
to get info out of the database, etc.

I guess you might say a real newbie tutorial.

Thanks
dawson

Re: Can't connect (error 2003) to mysql 5.0 on other server

[Mike Bosschaert]

Bingo!!
With the installation of the 5.0 (I assume) skip-networking was set by default 
in /etc/mysql/my.cnf. That was it.
Thanks.
Mike

> I assume you have already verified that the mysql server is actually
> running on server A.  Have you verified that server A is accepting tcp
> connections? Try running
>
>mysql -h mycompA -u mysql -p
>
> from server A.  If it lets you in, try
>
>SELECT CURRENT_USER();
>
> just to make sure it says @mycompA rather than @localhost.  Alternatively,
> try
>
>telnet mycompA 3306
>
> from both machines to see if you get an answer.
>
> If it doesn't let you in, check to see if mysql was started with
> --skip-networking on A, and look for anything which blocks mysql's port.
>
> Michael
>
> Mike Bosschaert wrote:
> > Hi,
> > I installed mysql 5.0 on server A and mysql 4.0 on server B. Starting
> >
> > mycompA$>mysql -h mycompB -u mysql -p
> >
> > on host A, I can connect and to the mysql-server on host B. However when
> > I start
> >
> > mycompB$>mysql -h mycompA -u mysql -p
> >
> > on host B, I get the error message:
> > ERROR 2003: Can't connect to MySQL server on 'mycompA' (111)
> >
> > On mycompA the user [EMAIL PROTECTED] has all privileges.
> >
> > This is what tcpdump reports:
> > tcpdump: listening on eth1 port 3306
> > 13:50:32.732182 mycompB.33431 > mycompA.mysql: S 2312810184:2312810184(0)
> > win 5840  (DF)
> > 13:50:32.732570 mycompA.mysql > mycompBt.33431: R 0:0(0) ack 2312810185
> > win 0 (DF)
> >
> > Any suggestions?
> >
> > Mike


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't connect (error 2003) to mysql 5.0 on other server

[Michael Stassen]

I assume you have already verified that the mysql server is actually running 
on server A.  Have you verified that server A is accepting tcp connections? 
 Try running

  mysql -h mycompA -u mysql -p

from server A.  If it lets you in, try

  SELECT CURRENT_USER();

just to make sure it says @mycompA rather than @localhost.  Alternatively, try

  telnet mycompA 3306

from both machines to see if you get an answer.

If it doesn't let you in, check to see if mysql was started with 
--skip-networking on A, and look for anything which blocks mysql's port.

Michael

Mike Bosschaert wrote:

Hi,
I installed mysql 5.0 on server A and mysql 4.0 on server B. Starting 

mycompA$>mysql -h mycompB -u mysql -p 

on host A, I can connect and to the mysql-server on host B. However when I 
start 

mycompB$>mysql -h mycompA -u mysql -p

on host B, I get the error message:
ERROR 2003: Can't connect to MySQL server on 'mycompA' (111)
On mycompA the user [EMAIL PROTECTED] has all privileges.

This is what tcpdump reports:
tcpdump: listening on eth1 port 3306
13:50:32.732182 mycompB.33431 > mycompA.mysql: S 2312810184:2312810184(0) win 
5840  (DF)
13:50:32.732570 mycompA.mysql > mycompBt.33431: R 0:0(0) ack 2312810185 win 0 
(DF)

Any suggestions?

Mike



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unable to connect to mysql with phpmyadmin

[Michael Stassen]

Marvin Cummings wrote:

I've tried it both ways using the default root and no password and root with
my assigned password. Either way returns an error. Here's a part of my
config.inc.php file:
// The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use
$cfg['Servers'][0].
// You can disable a server config entry by setting host to ''.
$i++;
$cfg['Servers'][$i]['host']  = 'localhost'; // MySQL hostname or IP
address

$cfg['Servers'][$i]['auth_type'] = 'HTTP';// Authentication method
(config, http or cookie based)?
$cfg['Servers'][$i]['user']  = 'root';  // MySQL user
$cfg['Servers'][$i]['password']  = '';  // MySQL password (only
needed
// with 'config'
auth_type)

Again I've tried it with 'config' and 'HTTP' as the 'auth_type' with and
without a password. I'm sure I'm missing something. 

 Thanks again
I know you must be frustrated, but [EMAIL PROTECTED] either has a password or 
it doesn't -- there's no sense trying the other.  From your description, I 
take it that root does have a password.

First, verify that the password works.  Try

  mysql -u root -p

at the command line, and enter the password when prompted.  If that works, 
then you know that you have the correct user-password combination for mysql. 
 Be sure to tell us that this worked (or didn't) in your next post. 
Assuming it worked, you'll see something like, "Your MySQL connection id is 
13 to server version: 4.0.17" on the second line.  Make note of the server 
version number and tell us what it is.

The next step is to see if we can get PHP/phpmyadmin to talk to mysql.  The 
simplest (Note, I did not say best.) way is to use config.  So, in your 
config.inc.php, set auth_type to config, and password to your mysql root 
password.  This should work, but from what you've said, it won't.  In your 
next post, tell us what error message you get in this case, particularly 
whether it says "YES" or "NO".

Finally, tell us some more about your setup.  I imagine you have the latest 
phpmyadmin, as you just set it up.  What about PHP?  We need to know 2 
things: which version of PHP you have, and which version of MySQL it was 
built against.  If I recall correctly, PHP's built-in MySQL support is 
version 3.23.49, which is rather old.  MySQL's authentication mechanism has 
been changed in 4.1 and later.  If you don't know the answers to those 2 
questions, make a file in your webspace (same directory as config.inc.php 
would do) with

  

as the contents.  Pull that up in your web brpwser to see a ton of info. 
The version of PHP will be right at the top, and MySQL support info will be 
down in the mysql section.  Tell us what it says for "Client API version".

I know I'm asking you to do a couple of things you've already done, but it's 
difficult to troubleshoot when we can't be sure exactly which error message 
went with which attempt.  My hope is that with specific info, we'll be able 
to narrow down where the problem lies.

Michael

P.S.  Note that using auth_type=config in your config.inc.php along with 
your mysql root password means that anyone who can access phpmyadmin will 
have root access to mysql.  So, once you get this working, you will need to 
either protect access to phpmyadmin or switch to another auth_type.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Deleting records using the 'LIMIT' clause

[Michael Stassen]

Harald Fuchs wrote:

In article <[EMAIL PROTECTED]>,
Ross Honniball <[EMAIL PROTECTED]> writes:
Hi all,
I have positively identified the row I want to delete using:

'SELECT * FROM table LIMIT 10,1'
No, you didn't.  Since you did not include an ORDER BY clause, MySQL
has returned the tenth row according to some completely arbitrary
order criterion.
This has returned 1 record and I now want to DELETE the record.
How do I identify this record in my DELETE statement?
(using 'DELETE FROM table LIMIT 10,1' does not work)
NOTE : I can't identify it using it's key fields as the table has no
primary key.
If you can't identify a record, how are you going to delete it?
Maybe all columns together are something unique; then you can say
  DELETE FROM tbl
  WHERE col1 = val1
AND col2 = val2
AND col3 = val3
...
Right.  But first you should test it.  Try

  SELECT * FROM tbl
  WHERE col1 = val1
AND col2 = val2
AND col3 = val3
to make sure that returns only the row you want to delete.  If it does, then 
 run the delete.

And if no combination of columns uniquely identifies a row (you have 
duplicates), then you must add a primary key column, probably an 
AUTO_INCREMENT.  You probably ought to do that anyway.

Michael



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Replication error

[Ugo Bellavance]

Hi,

I'm trying to do a replication of two servers (one is mysql version 
4.1.0-alpha-debug-debug (slave) on debian and the other is 4.1.0-alpha-debug-debug-log 
(master) on RH9).  No I can't upgrade for now.

What I've done is that I stopped the master, copied the data folder to the slave.  I 
got the data from SHOW MASTER STATUS and input it in the slave, and created the user 
on the master, as directed.

The problem is that when I START SLAVE, I get this error: ERROR 1200: The server is 
not configured as slave, fix in config file or with CHANGE MASTER TO

The problem might be caused by the fact that I have a firewall with nat between them, 
but I set up the user accordingly ([EMAIL PROTECTED] name of the firewall].  The slave 
is able to reach port 3306 on the master and port-forwarding is enabled on the 
firewall, forwarding port 3306 to the slave.

SHOW MASTER STATUS on the master:

mysql> show master status;
+--+--+--+--+
| File | Position | Binlog_do_db | Binlog_ignore_db |
+--+--+--+--+
| bobby-bin.23 |   79 |  |  |
+--+--+--+--+
1 row in set (0.00 sec)


Thanks
-- 
Ugo Bellavance
 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

compiling mysql and mysql crashing

[Christine Ross]

I had to install a source version of mysql and one of the install docs
strongly suggests using

CXXFLAGS="03 -felide-constructors -fno-exceptions -fno-rtti"

because of some instances of mysql crashing.

When I did that I noticed in the compile a line that said it wasn't
supported by gcc (3.3.3). I"m using CXX=gcc.

1)  Has anyone had instances if it crashing without those parameters?

I can't have mysql crashing but if the gcc indicates it doesn't support it,
do those flags get built in?


Also when I included it in the build, my statement
about --localstatedir=/usr/local/mysql/data

was ignored because it never built the data directory.

2) I just built it with --prefix and --localstatedir.  Has anyone had
problems with this?


3)  If I want to recompile mysql, do I also have to recompile all apache,
php and mod_ssl?



Thanks for any suggestions.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't connect (error 2003) to mysql 5.0 on other server

[Mike Bosschaert]

Hi,
I installed mysql 5.0 on server A and mysql 4.0 on server B. Starting 

mycompA$>mysql -h mycompB -u mysql -p 

on host A, I can connect and to the mysql-server on host B. However when I 
start 

mycompB$>mysql -h mycompA -u mysql -p

on host B, I get the error message:
ERROR 2003: Can't connect to MySQL server on 'mycompA' (111)

On mycompA the user [EMAIL PROTECTED] has all privileges.

This is what tcpdump reports:
tcpdump: listening on eth1 port 3306
13:50:32.732182 mycompB.33431 > mycompA.mysql: S 2312810184:2312810184(0) win 
5840  (DF)
13:50:32.732570 mycompA.mysql > mycompBt.33431: R 0:0(0) ack 2312810185 win 0 
(DF)

Any suggestions?

Mike

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Unable to connect to mysql with phpmyadmin

[Marvin Cummings]

I've tried it both ways using the default root and no password and root with
my assigned password. Either way returns an error. Here's a part of my
config.inc.php file:

// The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use
$cfg['Servers'][0].
// You can disable a server config entry by setting host to ''.
$i++;
$cfg['Servers'][$i]['host']  = 'localhost'; // MySQL hostname or IP
address
$cfg['Servers'][$i]['port']  = '';  // MySQL port - leave
blank for default port
$cfg['Servers'][$i]['socket']= '';  // Path to the socket -
leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'tcp';   // How to connect to
MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress']  = FALSE;   // Use compressed
protocol for the MySQL connection
// (requires PHP >=
4.3.0)
$cfg['Servers'][$i]['controluser']   = '';  // MySQL control user
settings
// (this user must have
read-only
$cfg['Servers'][$i]['controlpass']   = '';  // access to the
"mysql/user"
// and "mysql/db"
tables).
// The controluser is
also
// used for all
relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'HTTP';// Authentication method
(config, http or cookie based)?
$cfg['Servers'][$i]['user']  = 'root';  // MySQL user
$cfg['Servers'][$i]['password']  = '';  // MySQL password (only
needed
// with 'config'
auth_type)
$cfg['Servers'][$i]['only_db']   = '';  // If set to a db-name,
only
// this db is displayed
in left frame
// It may also be an
array of db-names, where sorting order is relevant.
$cfg['Servers'][$i]['verbose']   = '';  // Verbose name for this
host - leave blank to show the hostname

Again I've tried it with 'config' and 'HTTP' as the 'auth_type' with and
without a password. I'm sure I'm missing something. 

 Thanks again

-Original Message-
From: Kenny Phipps [mailto:[EMAIL PROTECTED] 
Sent: Saturday, April 03, 2004 11:38 PM
To: Marvin Cummings
Subject: RE: Unable to connect to mysql with phpmyadmin

Are you using the username and password in the config file? or the 
username and password for sql?  For phpmyadmin, you use the username 
and password in the config file.

> Ok. I'm using the default config.inc.php file which has 'config' as 
the
> 'auth_type'. I change this to HTTP and I'm prompted to enter a 
username and
> password. I try root and its password and get "You are not authorized 
to
> view this page". This happens regardless of the account I use. I know 
I'm
> missing something here and it's driving me crazy. 
> 
> Thanks for the help. 
> 
> -Original Message-
> From: Eve Atley [mailto:[EMAIL PROTECTED] 
> Sent: Saturday, April 03, 2004 9:54 PM
> To: Marvin Cummings
> Subject: Re: Unable to connect to mysql with phpmyadmin
> 
> > I see $cfg all over the place and no mention of HTTP. Where should 
I be
> > looking for this?
> > 
> > Thanks
> 
> 
> Hi,
> 
> Sent you a screenshot to give you an idea of how I'm running mine 
with root.
> You can set it to HTTP (which prompts you) or to 'Config'. Try 
leaving out
> the password and just put root as the username.
> 
> - Eve
> 
> 
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
> 
> 
> 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]