Databases not seen in MySQLCC

2004-06-17 Thread Marvin Cummings 
Have a strange problem where only one of my databases shows up in the
MySQLCC console, yet if I look in the MySQL Admin console all databases
are seen. Anyone experience this before?

Disconnect odbc from localhost

2004-05-09 Thread Marvin Cummings 
Can someone please advise me on how to prevent the [EMAIL PROTECTED]
connection? This is preventing me from accessing any of my databases in
phpMyAdmin. 

Any responses are appreciated. 

Thanks

Error creating table in MySQL 5.0

2004-05-09 Thread Marvin Cummings 
Wondering if anyone can give me some help with this error I'm getting
when trying to create this table:

 

ERROR 1064 (42000): You have an error in your SQL syntax.  Check the
manual that

 corresponds to your MySQL server version for the right syntax to use
near '$sql

 = CREATE TABLE $subdivtable (

$subdivcolumn[subdiv_title] varchar(50),

$su' at line 1

 

The syntax I'm using to create this table: 

 

...\bin\Mysql $sql = CREATE TABLE $subdivtable ( 
$subdivcolumn[subdiv_title] varchar(50), 
$subdivcolumn[subdiv_id] int(4) DEFAULT '0' NOT NULL
auto_increment, 
$subdivcolumn[country_id] int(4) NOT NULL, 
PRIMARY KEY(subdiv_id)); 

 

I'm running mysql 5.0 on a w2k3 server.

RE: MySQL 5.0.0-alpha-max-debug running on localhost as ODBC@localhost

2004-04-19 Thread Marvin Cummings 
I'm not actually getting an error. I'm simply unable to access any of my
databases while logged in as [EMAIL PROTECTED] I'd like to change this and
specify what account is used to establish a connection. How and where do I
make this change in MySQL? 

Thanks

-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 16, 2004 10:22 AM
To: [EMAIL PROTECTED]
Subject: Re: MySQL 5.0.0-alpha-max-debug running on localhost as
[EMAIL PROTECTED]

Marvin Cummings [EMAIL PROTECTED] wrote:
 This appears when I attempt to open phpMyAdmin. It doesn't matter what
 account I set in the config.inc.php file, I continue to get this error.
How
 do I change this so that another account logs in to the localhost? I
 unfortunately had to reboot my server and this became the result. I notice
 that I can log in to MySQLCC and the command line as root without a
problem.

What error do you get?




-- 
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]


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

MySQL 5.0.0-alpha-max-debug running on localhost as ODBC@localhost

2004-04-15 Thread Marvin Cummings 
This appears when I attempt to open phpMyAdmin. It doesn't matter what
account I set in the config.inc.php file, I continue to get this error. How
do I change this so that another account logs in to the localhost? I
unfortunately had to reboot my server and this became the result. I notice
that I can log in to MySQLCC and the command line as root without a problem.


 

Thanks

RE: Need help creating table...

2004-04-07 Thread Marvin Cummings 
That did it. I really do appreciate all of the help that I received from you
and the list. 

Thanks again. :)

-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 06, 2004 7:52 PM
To: Marvin Cummings
Cc: [EMAIL PROTECTED]
Subject: Re: Need help creating table...

Sorry.  I can imagine how frustrated you must be.

In mysql 5, condition is a reserved word, so the person who told you to 
remove the quotes was wrong, at least for that column.  (In his defense, 
CONDITION is relevant to stored procedures, so it isn't a reserved word for 
versions prior to 5, as far as I know.)

You will need to put bacticks around the column name, like this

   `condition` varchar(10) NOT NULL default '',

Michael

Marvin Cummings wrote:

 Thanks for the responses but after copying and pasting this into the
mysql command prompt I now get the following error: 
 
 Error 1064 (42000): You have an error in your SQL syntax. Check the manual
 that corresponds to your MySQL version for the right syntax to use near
 condition varchar(10) NOT NULL default '', 
 City varchar(20) NOT NULL default '', at line 8
 
 I copy this exactly like it is: 
 
 CREATE TABLE 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 ;
 
 And it still isn't working!!! 
 WHAT am I doing wrong here? 
 
 Thanks again for the help. 
 


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

FW: Need help creating table using phpMyAdmin

2004-04-06 Thread Marvin Cummings 


-Original Message-
From: Marvin Cummings [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 06, 2004 3:11 AM
To: 'Michael Stassen'
Subject: RE: Need help creating table using phpMyAdmin

I attempt to create this table from the command line and get the following
error: 
Error 1064 (42000): You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL version for the right syntax to use near
''ad_id' smallint(5) unsigned NOT NULL auto_increment, 
'cat_id' smallint(5) unsign' at line 3

I'm typing this exactly as it appears but it's not working. I also try to
create this table in phpMyAdmin: 
Field  Type 
ad_id  SmallInt 5  

Length/Values
5

Charset
Latin1

Attributes
unsigned

Null
Not_null

Default**
? 

Extra
auto_increment   

I'm not sure what to enter for Default**. Can someone tell me what I'm
missing? 

Thanks

-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 05, 2004 2:34 AM
To: Marvin Cummings
Cc: [EMAIL PROTECTED]
Subject: Re: Need help creating table using phpMyAdmin


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...

2004-04-06 Thread Marvin Cummings 
 

 

  _  

From: Marvin Cummings [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 06, 2004 9:26 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Need help creating table...

 

I attempt to create this table from the command line and get the following
error: 

Error 1064 (42000): You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL version for the right syntax to use near
''ad_id' smallint(5) unsigned NOT NULL auto_increment, 'cat_id' smallint(5)
unsign' at line 3

CREATE TABLE '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'm typing this exactly as it appears but it's not working. I also try to
create this table in phpMyAdmin but have a question: 

Field  Type 

ad_id  SmallInt 5  

 

Length/Values

5

 

Charset

Latin1

 

Attributes

unsigned

 

Null

Not_null

 

Default**

? 

 

Extra

auto_increment   

 

I'm not sure what to enter for Default**. Can someone tell me what I'm
missing? 

I'm using MySQL5.0alpha w/PHP4.3.4 on W2K3.

 

Thanks

Need help creating table using phpMyAdmin

2004-04-05 Thread 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.

RE: Unable to connect to mysql with phpmyadmin

2004-04-04 Thread 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]

RE: Unable to connect to mysql with phpmyadmin

2004-04-04 Thread 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
SNIP
 $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)
SNIP
 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

   ?php phpinfo() ?

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]

Unable to connect to mysql with phpmyadmin

2004-04-03 Thread Marvin Cummings 
I'm wondering if someone could help me figure out why I'm getting this error
when attempting to use phpMyAdmin to connect to mysql: 

phpMyAdmin tried to connect to the MySQL server, and the server rejected the
connection. You should check the host, username and password in
config.inc.php and make sure that they correspond to the information given
by the administrator of the MySQL server.

Error

MySQL said: 

#1045 - Access denied for user: 'root'@'localhost' (Using password: NO) or
YES

 

It doesn't seem to matter if I add a password or not. I'm able to connect to
MySQL using both MySQLCC and MySQLAdmin using root and my other accounts so
I know the passwords are correct. I'm trying to follow the documentation
that came with phpMyAdmin but I'm obviously missing something. Would someone
happen to have a detailed way of editing this file to allow connectivity? 

 

Many thanks in advance

RE: Unable to connect to mysql with phpmyadmin

2004-04-03 Thread Marvin Cummings 
I see $cfg all over the place and no mention of HTTP. Where should I be
looking for this? 

Thanks

-Original Message-
From: Eve Atley [mailto:[EMAIL PROTECTED] 
Sent: Saturday, April 03, 2004 9:36 PM
To: Marvin Cummings
Subject: Re: Unable to connect to mysql with phpmyadmin


In the config file, are you using CONFIG or HTTP? Config shouldn't need a
password, HTTP will for sure.

- Eve




-- 
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

2004-04-03 Thread Marvin Cummings 
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/[EMAIL PROTECTED]

Possible OT: Unable to make database error...

2004-03-21 Thread Marvin Cummings 
I'm getting the following error while trying to install PostNuke ver.726 on
a w2k3 server that's running IIS6, MySQL 5 and PHP4.3.4. I've used both
MySQLCC and MySQLAdmin to create users with the necessary permissions to
connect to the databases. I even tried the command line using GRANT ALL
PRIVILEGES ON dbname.* TO dbuser@dbhost IDENTIFIED BY 'dbpass' WITH
GRANT OPTION;

 

But it didn't work. Instead it returned an error informing me that I had an
error in my sql syntax. The users are able to connect without problem. 

Hoping someone here will have an idea on what it is I'm doing wrong. 

 

Thanks

FW: local installation on XP

2004-03-21 Thread Marvin Cummings 

Do you see a green light in the WinMySQL Tool? 
Have you insalled MySQLODBC ver3.51? If so pull up a command prompt and type
c:\mysql\bin mysqld --console
Also type
c:\mysql\bin mysqld --install

Try this doc:
http://www.mysql.com/doc/en/Windows_post-installation.html

HTH

-Original Message-
From: A Mathias [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 21, 2004 4:16 PM
To: mysql
Subject: local installation on XP

I've just installed mySQL locally on XP and am getting the following error
while trying to connect via mySQLCC. I have checked the username and
password and things are ok there. XP is running the mysql-nt.exe fine, but
still no go when I try to connect, any ideas??

  
#This File was made using the WinMySQLAdmin 1.4 Tool
#3/20/2004 6:28:50 PM

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/mysql
#bind-address=67.234.135.56
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=**
password=*


A Mathias


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

RE: local installation on XP

2004-03-21 Thread Marvin Cummings 
Check you Windows directory for these files: 
a. myodbc3.dll
b. myodbc3.lib
c. myodbc3_install.log
d. myodbc3d.dll

Open a command prompt and attempt to start the service by navigating to the
mysql\bin directory and typing 
mysqld --console - this runs some INNODB commands
mysqld --install - this starts the mysql service

hth

-Original Message-
From: A Mathias [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 21, 2004 5:17 PM
To: Marvin Cummings
Subject: RE: local installation on XP

Got it 3.51 installed, but still getting 1045 Error from mySQLcc


 [Original Message]
 From: Marvin Cummings [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Date: 3/21/2004 3:04:31 PM
 Subject: RE: local installation on XP

 Yes it is. MySQL.com -- Downloads

 -Original Message-
 From: A Mathias [mailto:[EMAIL PROTECTED] 
 Sent: Sunday, March 21, 2004 4:58 PM
 To: Marvin Cummings
 Subject: RE: local installation on XP

 Yes, there is a Green light on the WinMySQL tool, but in the enviorment
TAB
 it show's that myODBC 3.51 driver not found. How do I get this? is it on
 the mySQL site? 


  [Original Message]
  From: Marvin Cummings [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Date: 3/21/2004 2:36:19 PM
  Subject: RE: local installation on XP
 
  Do you see a green light in the WinMySQL Tool? 
  Have you insalled MySQLODBC ver3.51? If so pull up a command prompt and
 type
  c:\mysql\bin mysqld --console
  Also type
  c:\mysql\bin mysqld --install
 
  Try this doc:
  http://www.mysql.com/doc/en/Windows_post-installation.html
 
  HTH
 
  -Original Message-
  From: A Mathias [mailto:[EMAIL PROTECTED] 
  Sent: Sunday, March 21, 2004 4:16 PM
  To: mysql
  Subject: local installation on XP
 
  I've just installed mySQL locally on XP and am getting the following
error
  while trying to connect via mySQLCC. I have checked the username and
  password and things are ok there. XP is running the mysql-nt.exe fine,
but
  still no go when I try to connect, any ideas??
 

  #This File was made using the WinMySQLAdmin 1.4 Tool
  #3/20/2004 6:28:50 PM
 
  #Uncomment or Add only the keys that you know how works.
  #Read the MySQL Manual for instructions
 
  [mysqld]
  basedir=C:/mysql
  #bind-address=67.234.135.56
  datadir=C:/mysql/data
  #language=C:/mysql/share/your language directory
  #slow query log#=
  #tmpdir#=
  #port=3306
  #set-variable=key_buffer=16M
  [WinMySQLadmin]
  Server=C:/mysql/bin/mysqld-nt.exe
  user=**
  password=*
 
 
  A Mathias







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

RE: [WDG] Client doesn't support authentication protocol error inMySQL

2004-03-21 Thread Marvin Cummings 
Cool and thanks for the update. In trying to configure my server to use old
passwords I'm having a problem with one of the commands listed on the site: 
This command works fine.
mysql SET PASSWORD FOR
- 'some_user'@'some_host' = OLD_PASSWORD('mypass');
   
I get an error after attempting to issue this command: 
mysql UPDATE user SET Password = OLD_PASSWORD('mypass')
- WHERE Host = 'some_host' AND User = 'some_user';

I get the following error: 
Error 1064 (3D000): No database selected

I don't see mention to select a database here. Am I possibly using the wrong
commands? 

Thanks

-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 21, 2004 7:43 PM
To: Marvin Cummings; [EMAIL PROTECTED]
Subject: RE: [WDG] Client doesn't support authentication protocol error
inMySQL

At 19:29 -0500 3/21/04, Marvin Cummings wrote:
Then again according to the MySQL website:
The Windows download contains both the Standard and Max server binaries. It
also contains a version of the command-line client which uses the Cygwin
library to provide command history and editing.
Would someone happen to know if there are any client libraries that need
updating on mysql 5.0?

Sounds like PHP itself needs to have its MySQL client libraries updated.
EIther that or you'll need to run your 5.0 server with --old-passwords.

By the way...
I'm removing the extra To: addresses because the cause bounces for anyone
who replies to your message from [EMAIL PROTECTED] who isn't subscribed
to those other lists.


Thanks

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Marvin Cummings
Sent: Sunday, March 21, 2004 7:18 PM
To: [EMAIL PROTECTED]
Subject: RE: [WDG] Client doesn't support authentication protocol error
inMySQL

Nope I didn't compile PHP using the client libraries or validate the
install
using a later version of MySQL. Once I managed to get it, 5.0, working I
went strait to the PHP install without thinking about any of this. Lemme
see
if I can do this without installing a later version of MySQL.

Thanks

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Hassan Schroeder
Sent: Sunday, March 21, 2004 7:00 PM
To: [EMAIL PROTECTED]
Subject: Re: [WDG] Client doesn't support authentication protocol error
inMySQL

Marvin Cummings wrote:

  Wondering if anyone running MySQL 5 has come across the following error:


  Error (1250) : Client does not support authentication protocol requested
  by server; consider upgrading MySQL client

  I get this error after attempting to install PN on a Windows 2003 web
  server. I've already created the database and granted the root user
  account permissions to it. I'm not sure if there's anything else I need
  to upgrade MySQL to.

Well, I'm not running MySQL 5 yet, even in test, but the error
message seems pretty straightforward. Did you compile PHP using
the MySQL 5 client libraries?

Or, have you tried this using a production (4.0.x) version of
MySQL as a first step to validate the install?

--
Hassan Schroeder - [EMAIL PROTECTED]
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

dream.  code.


-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/


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

RE: [WDG] Client doesn't support authentication protocol error inMySQL

2004-03-21 Thread Marvin Cummings 
Success I got it working after changing my password using this command: 
mysql SET PASSWORD FOR
- 'some_user'@'some_host' = OLD_PASSWORD('mypass');

Afterwards I was able to log in via a DOS prompt. I then re-ran the PN
install and it installed like it should. 

Thanks for that link and the help Paul. 

-Original Message-
From: Marvin Cummings [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 21, 2004 8:03 PM
To: 'Paul DuBois'
Cc: [EMAIL PROTECTED]
Subject: RE: [WDG] Client doesn't support authentication protocol error
inMySQL

Cool and thanks for the update. In trying to configure my server to use old
passwords I'm having a problem with one of the commands listed on the site: 
This command works fine.
mysql SET PASSWORD FOR
- 'some_user'@'some_host' = OLD_PASSWORD('mypass');
   
I get an error after attempting to issue this command: 
mysql UPDATE user SET Password = OLD_PASSWORD('mypass')
- WHERE Host = 'some_host' AND User = 'some_user';

I get the following error: 
Error 1064 (3D000): No database selected

I don't see mention to select a database here. Am I possibly using the wrong
commands? 

Thanks

-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 21, 2004 7:43 PM
To: Marvin Cummings; [EMAIL PROTECTED]
Subject: RE: [WDG] Client doesn't support authentication protocol error
inMySQL

At 19:29 -0500 3/21/04, Marvin Cummings wrote:
Then again according to the MySQL website:
The Windows download contains both the Standard and Max server binaries. It
also contains a version of the command-line client which uses the Cygwin
library to provide command history and editing.
Would someone happen to know if there are any client libraries that need
updating on mysql 5.0?

Sounds like PHP itself needs to have its MySQL client libraries updated.
EIther that or you'll need to run your 5.0 server with --old-passwords.

By the way...
I'm removing the extra To: addresses because the cause bounces for anyone
who replies to your message from [EMAIL PROTECTED] who isn't subscribed
to those other lists.


Thanks

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Marvin Cummings
Sent: Sunday, March 21, 2004 7:18 PM
To: [EMAIL PROTECTED]
Subject: RE: [WDG] Client doesn't support authentication protocol error
inMySQL

Nope I didn't compile PHP using the client libraries or validate the
install
using a later version of MySQL. Once I managed to get it, 5.0, working I
went strait to the PHP install without thinking about any of this. Lemme
see
if I can do this without installing a later version of MySQL.

Thanks

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Hassan Schroeder
Sent: Sunday, March 21, 2004 7:00 PM
To: [EMAIL PROTECTED]
Subject: Re: [WDG] Client doesn't support authentication protocol error
inMySQL

Marvin Cummings wrote:

  Wondering if anyone running MySQL 5 has come across the following error:


  Error (1250) : Client does not support authentication protocol requested
  by server; consider upgrading MySQL client

  I get this error after attempting to install PN on a Windows 2003 web
  server. I've already created the database and granted the root user
  account permissions to it. I'm not sure if there's anything else I need
  to upgrade MySQL to.

Well, I'm not running MySQL 5 yet, even in test, but the error
message seems pretty straightforward. Did you compile PHP using
the MySQL 5 client libraries?

Or, have you tried this using a production (4.0.x) version of
MySQL as a first step to validate the install?

--
Hassan Schroeder - [EMAIL PROTECTED]
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

dream.  code.


-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/


-- 
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]

Bad syntax when trying to create mysql username and password...

2004-03-21 Thread Marvin Cummings 
Can someone take a look and let me know what's wrong with this command: 

GRANT ALL PRIVILEGES ON dbname.* TO dbuser@dbhost IDENTIFIED BY
'dbpass' WITH GRANT OPTION;

 

So for me I say: 

GRANT ALL PRIVILEGES ON testdb.* TO [EMAIL PROTECTED] IDENTIFIED BY mypassword
WITH GRANT OPTION;

 

It returns the following error: 

Error 1064 42000: You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'mypassword with grant option' at line 2. 

 

I have absolutely no idea what this means. I'm issuing this under w2k3 on
mysql 5. Would anyone happen to know of a way to troubleshoot this? 

 

Thanks

RE: Bad syntax when trying to create mysql username and password...

2004-03-21 Thread Marvin Cummings 
Ahhh. I didn't pay any attention to the quotes. 

Thanks

-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED] 
Sent: Sunday, March 21, 2004 6:22 PM
To: Marvin Cummings; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Bad syntax when trying to create mysql username and password...

At 18:11 -0500 3/21/04, Marvin Cummings wrote:
Can someone take a look and let me know what's wrong with this command:

GRANT ALL PRIVILEGES ON dbname.* TO dbuser@dbhost IDENTIFIED BY
'dbpass' WITH GRANT OPTION;



So for me I say:

GRANT ALL PRIVILEGES ON testdb.* TO [EMAIL PROTECTED] IDENTIFIED BY mypassword
WITH GRANT OPTION;

You're not quoting the password.  It's a string.  That's why the error
message says the beginning of the problematic part of the statement
is at 'mypassword with grant option' at line 2.




It returns the following error:

Error 1064 42000: You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'mypassword with grant option' at line 2.


-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/


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

Client doesn't support authentication protocol error in MySQL

2004-03-21 Thread Marvin Cummings 
Wondering if anyone running MySQL 5 has come across the following error:  

 

Error (1250) : Client does not support authentication protocol requested by
server; consider upgrading MySQL client

 

I get this error after attempting to install PN on a Windows 2003 web
server. I've already created the database and granted the root user account
permissions to it. I'm not sure if there's anything else I need to upgrade
MySQL to. 

 

Thanks

RE: [WDG] Client doesn't support authentication protocol error inMySQL

2004-03-21 Thread Marvin Cummings 
Then again according to the MySQL website: 
The Windows download contains both the Standard and Max server binaries. It
also contains a version of the command-line client which uses the Cygwin
library to provide command history and editing.
Would someone happen to know if there are any client libraries that need
updating on mysql 5.0? 

Thanks

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Marvin Cummings
Sent: Sunday, March 21, 2004 7:18 PM
To: [EMAIL PROTECTED]
Subject: RE: [WDG] Client doesn't support authentication protocol error
inMySQL

Nope I didn't compile PHP using the client libraries or validate the install
using a later version of MySQL. Once I managed to get it, 5.0, working I
went strait to the PHP install without thinking about any of this. Lemme see
if I can do this without installing a later version of MySQL. 

Thanks

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Hassan Schroeder
Sent: Sunday, March 21, 2004 7:00 PM
To: [EMAIL PROTECTED]
Subject: Re: [WDG] Client doesn't support authentication protocol error
inMySQL

Marvin Cummings wrote:

 Wondering if anyone running MySQL 5 has come across the following error:  
 
 Error (1250) : Client does not support authentication protocol requested 
 by server; consider upgrading MySQL client
 
 I get this error after attempting to install PN on a Windows 2003 web 
 server. I've already created the database and granted the root user 
 account permissions to it. I'm not sure if there's anything else I need 
 to upgrade MySQL to.

Well, I'm not running MySQL 5 yet, even in test, but the error
message seems pretty straightforward. Did you compile PHP using
the MySQL 5 client libraries?

Or, have you tried this using a production (4.0.x) version of
MySQL as a first step to validate the install?

-- 
Hassan Schroeder - [EMAIL PROTECTED]
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

   dream.  code.



___
Wdg mailing list provided by ForwardWeb
http://www.forwardweb.com/
POSTS: [EMAIL PROTECTED]
Subscribe - Unsubscribe Information
http://wdguide.com/mailman/listinfo/wdg_wdguide.com


___
Wdg mailing list provided by ForwardWeb
http://www.forwardweb.com/
POSTS: [EMAIL PROTECTED]
Subscribe - Unsubscribe Information
http://wdguide.com/mailman/listinfo/wdg_wdguide.com


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

RE: In need of MSSQL help

2003-11-01 Thread Marvin Cummings 
I run the Upsize tool and attempt to convert the database to MSSQL.
Afterwards I can see the new database in SQL, but I'm not sure what to
do next? There's a total of 7 databases that I think make up one
complete database. 

-Original Message-
From: Dan Lampkin [mailto:[EMAIL PROTECTED] 
Sent: Saturday, November 01, 2003 1:05 AM
To: 'Marvin Cummings'; 'MySQL'
Subject: RE: In need of MSSQL help


There are several good resources for MS SQL.

www.sqlmag.com
and
www.sqlservercentral.com

are the two that I like best.

For the logins, what OS are you using?  For external users, you will
likely need SQL accounts, and if the internal accounts are using an MS
OS, you can use their Windows account for better security and easier
administration.  I'm not sure what you mean when you say accept reports
and applications?

HTH,

Dan


-Original Message-
From: Marvin Cummings [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 31, 2003 8:28 PM
To: MySQL
Subject: In need of MSSQL help

Hopefully this isn't too far off-topic but I need some help with an
Access database that I need to convert to MSSQL. I need to ensure that
this db can accept reports and applications, and then have a secure
login for both internal and external users. Would this be the list to
post to or would anyone know of any lists like this one that focuses on
MSSQL? 
 
TIA


-- 
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]

In need of MSSQL help

2003-10-31 Thread Marvin Cummings 
Hopefully this isn't too far off-topic but I need some help with an
Access database that I need to convert to MSSQL. I need to ensure that
this db can accept reports and applications, and then have a secure
login for both internal and external users. Would this be the list to
post to or would anyone know of any lists like this one that focuses on
MSSQL? 
 
TIA

Data not displaying correctly...

2002-09-26 Thread Marvin Cummings 

I need some help with a slight problem I'm having getting my data to display
to the correct page. What I'm trying to do is allow users to post data to
some pages on my site and make that data available for viewing.
So far I have it so that I can connect to the db and post the data to the
table. I can even display that data. The problem is that the data isn't
posting like it should. If userA post a poem to the poetry page, that data
should only display on the poetry page. If userB post an essay to the Essay
page, then that data is only displayed in the Essays section. Right now the
data is showing up on all pages. So userA's poem shows up in both the Poetry
 Essay pages.
Here's the code that I'm using:
?php
 // If the user wants to add a file
 if (isset($addfile)):
?
FORM ACTION=?php echo($PHP_SELF); ? METHOD=POST
PEnter your Essay here:/PBR
TEXTAREA NAME=Filedata ROWS=20 COLS=70 WRAP
CENTERb ENTER YOUR TITLE HERE /B/CENTER
P START TYPING YOUR POEM HERE /PBR
/TEXTAREABR
INPUT TYPE=SUBMIT NAME=submitform VALUE=SUBMIT
input type=reset name=clear value=Clear
/FORM/FONT

font face=verdana, arial, helvetica size=1
?php
 else:
// Connect to the database server
$dbcnx = @mysql_connect(localhost,
dbnubiint_user, dbusernu);
 if (!$dbcnx) {
   echo( PUnable to connect to the  .
database server at this time./P );
 exit();
}
   // Select the dbnubiint database
   if (! @mysql_select_db(dbnubiint) ) {
echo( PUnable to locate the file  .
  database at this time./P );
 exit();
}
// If a file has been submitted,
// add it to the database.
if (SUBMIT == $submitform) {
$sql = INSERT INTO nuwoez SET  .
   Filedata='$Filedata',  .
   Filetype='$Filetype',  .
   Author='$Author',  .
   City='$City',  .
   State='$State',  .
   Email='$Email',  .
   Title='$Title',  .
   Copyright='$Copyright',  .
   Category='$Category',  .
   Submitdate=CURDATE();
if (mysql_query($sql)) {
  echo(PThank You, Your work has been submitted./P);
} else {
  echo(PError adding submitted file:  .
mysql_error() . /P);
 }
}
echo(P Here are all the files  .
in our database: /P);

// Request the text of all the files
$result = mysql_query(
SELECT Filedata FROM nuwoez);
if (!$result) {
  echo(PError performing query:  .
mysql_error() . /P);
  exit();
}
// Display the text of each file in a paragraph
while ( $row = mysql_fetch_array($result) ) {
  echo(P . $row[Filedata] . /P);
}
// When clicked, this link will load this page
// with the file submission form displayed.
echo(PA HREF='$PHP_SELF?addfile=1' .
Click to Submit a Poem!/A/P);
  endif;
?

Also how can I get the data entered into the text fields to display when
submitted?
TIA
Any response on this is appreciated.


-
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

Slight problem storing data with Mysql...

2002-09-22 Thread Marvin Cummings 

MySQL newbie seeking help and/or advice on storing data into a database.
I have a poetry section I'm trying to add to my site that will allow users to submit 
some of their work for public viewing. An example is located here: 
http://www.nubiint.com/nuwoez/nuwoez.htm.
By clicking on any one of the categories listed in the menu, the user is presented 
with a link that will allow them to complete a form and enter their text to be stored 
in the db I've created and made available for public viewing. The problem is that the 
data doesn't appear to store in the table in the database. After adding some test data 
I'm able to see the row added to the table, but I'm unable to see or view anything 
else, for instance the date(s) or data that's set as a mediumblob. 
How can I view this data to ensure that it is indeed in the table? 
Also how can I reset the ID field? After I delete the test data the ID doesn't reset, 
it continues to count from the last ID. 
Also how can I change the display of the date field? It currently shows as -00-00. 
Is there anyway to change it to 
00-00-???

TIA...Any response is appreciated.

-
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: installin mysql on win 2000

2002-09-18 Thread Marvin Cummings 

I have it installed on my w2k w/sp3 server and I don't have any problems with it. 

-Original Message-
From: Ryan Cavanaugh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 3:23 PM
To: [EMAIL PROTECTED]
Subject: installin mysql on win 2000


I will begining to install mysql on my server in a few days.  I have never
done this before.  Is there anything i need to know, any problems mysql has
with 2000 server?  Any help is appreciated.

Ryan



-
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: questions

2002-09-16 Thread Marvin Cummings 

Sorry to piggy back on this topic, but would you happen to know of or have a link to a 
php discussion list?

-Original Message-
From: Kelly Firkins [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 12:12 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: questions


You'll want to post this question to the PHP lists. this error is 
coming from PHP indicating that it doesn't know about the MySQL 
functions. Either it wasn't compiled with mysql or it's mis-configured. 
Create a (haha.php) file with contents
?php
phpinfo();
?
And open it via your browser via the web server. It'll tell you how 
things are configured. Persons on the PHP lists may ask to see that 
page to help diagnose

Kelly

On Sunday, September 15, 2002, at 10:12  PM, raquel.esparagoza wrote:


 Hi,

 We are trying to MySQl for our discussion Forum, but when we try to 
 browse
 our php code, it is giving us this error:
 Fatal error: Call to undefined function: mysql_connect() in
 /var/www/html/board-tnk_v2.0/dbcreate.php3 on line 17

 May I know what is the possible problem? We are using RedHat Linux 7.3 
 on
 Kernel 2.4.18-3 on an i686, since there are Apache and PHP enabled on 
 this
 Linux we are just trying to use these applications. I checked the PhP 
 info
 it used .configure --with-mysql in configuration.

 Hoping for your response.

 Thanks in advance,

 Raquel Encia Esparagoza
 Consultant (eBusiness)



 -
 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

MySQL install on Linux 7.1

2002-07-10 Thread Marvin Cummings 

Hey can someone provide me some help in installing and configuring mysql ver3.23.51 on 
my Linux server? I downloaded the file from mysql.com to my servers hard drive and now 
want to install it. I right-clicked the installation file and clicked install. It 
appears to have installed something, but I can't find it. I looked in the /var/lib 
directories and don't see anything. Though the installation steps are covered somewhat 
on mysql.com, I'm still having problems as I'm totally new to linux. 
Any documented steps from a newbie's perspective or something simple would be really 
helpful.
Any help is appreciated. 

-
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

MySql install on W2K server running Apache ver2.0.39

2002-07-02 Thread Marvin Cummings 

Hello all...
I'm new to the list and to MySql and would like to get some advice on approaching my 
first mysql install.
I've just installed Apache ver2.0.39 onto my W2K server and I'm currently attempting 
to get PHP4 going. Can anyone provide me with some ideas on how to approach the mysql 
install? Is it anything like installing SQL 2000? Or should I treat it like Apache and 
approach it with a Linux Unix mentality? Which version should I choose? 
Let me say that I am still navigating my way through the mysql site, so I'm pretty 
sure that I'll eventually come across the answer to some of these questions. I'm 
mainly looking for hands on experience.
Thanks in advance.

-
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