/tmp/mysql.sock question (newbie)
Hello all, I would like to change where the /tmp/mysql.sock file gets created. How to I get it to create the file in another location? Thanks. - 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: /tmp/mysql.sock question (newbie)
There is a cleanup script run via cron that removes files from /tmp. When I try to stop the db, I get an error message that the socket cannot be found. |-+ | | Adolfo Bello | | | adolfobello@bisa| | | pi.com | | || | | 11/11/2002 04:32 | | | PM | | || |-+ --| | | | To: Black, Kelly W [PCS] [EMAIL PROTECTED] | | cc: Mysql Lists [EMAIL PROTECTED] | | Subject: RE: /tmp/mysql.sock question (newbie) | --| I am also a newbie so don't misunderstand my question. Is there any performance or functionality reason to change mysql.sock location? Adolfo On Mon, 2002-11-11 at 14:37, Black, Kelly W [PCS] wrote: You can do this in /etc/my.cnf ~K Black -Original Message- From: [EMAIL PROTECTED] [mailto:CZachary;wiley.com] Sent: Monday, November 11, 2002 10:05 AM To: [EMAIL PROTECTED] Subject: /tmp/mysql.sock question (newbie) Hello all, I would like to change where the /tmp/mysql.sock file gets created. How to I get it to create the file in another location? Thanks. - 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
Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)
Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on
Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3.
I am trying to connect to my Mysql DB via Apache and PHP, but I get the
following error: Warning: MySQL Connection Failed: Access denied for
user: 'root@jws-portald' (Using password: YES) in helloSql.php on line 3
Could not connect
Is there a step I missed during the Mysql setup?
Here is the code I used.
?php
// Connecting, selecting database
$link = mysql_connect(localhost, root, mypassword)
or die(Could not connect);
print Connected successfully;
// Performing SQL query
$query = SELECT now();
$result = mysql_query($query)
or die(Query failed);
// Printing results in HTML
print table\n;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print \ttr\n;
foreach ($line as $col_value) {
print \t\ttd$col_value/td\n;
}
print \t/tr\n;
}
print /table\n;
// Closing connection
mysql_close($link);
?
-
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: Error connecting to Mysql via Apache/PHP - Access Denied (Newbie)
I tried this. The error I received is: error: 'Access denied for user:
'root@localhost' (Using password: NO)'
Is there another option?
|-+
| | Dan Rossi |
| | daniel@electrote|
| | que.org |
| ||
| | 11/08/2002 11:10 |
| | AM |
| ||
|-+
--|
|
|
| To: [EMAIL PROTECTED], [EMAIL PROTECTED]
|
| cc:
|
| Subject: RE: Error connecting to Mysql via Apache/PHP - Access Denied
(Newbie) |
--|
mysqladmin -u root password setpassword ? and dont use root for normal
access
-Original Message-
From: [EMAIL PROTECTED] [mailto:CZachary;wiley.com]
Sent: Saturday, November 09, 2002 2:51 AM
To: [EMAIL PROTECTED]
Subject: Error connecting to Mysql via Apache/PHP - Access Denied
(Newbie)
Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on
Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3.
I am trying to connect to my Mysql DB via Apache and PHP, but I get the
following error: Warning: MySQL Connection Failed: Access denied for
user: 'root@jws-portald' (Using password: YES) in helloSql.php on line 3
Could not connect
Is there a step I missed during the Mysql setup?
Here is the code I used.
?php
// Connecting, selecting database
$link = mysql_connect(localhost, root, mypassword)
or die(Could not connect);
print Connected successfully;
// Performing SQL query
$query = SELECT now();
$result = mysql_query($query)
or die(Query failed);
// Printing results in HTML
print table\n;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print \ttr\n;
foreach ($line as $col_value) {
print \t\ttd$col_value/td\n;
}
print \t/tr\n;
}
print /table\n;
// Closing connection
mysql_close($link);
?
-
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
Error connecting to Mysql via Apache/PHP (Newbie)
Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on
Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3.
I am trying to connect to my Mysql DB via Apache and PHP, but I get the
following error: Warning: Unknown MySQL Server Host '' (1) in
helloSql.php on line 3 Warning: MySQL Connection Failed: Unknown MySQL
Server Host '' (1) in helloSql.php on line 3 Could not connect
Here is the code I used.
?php
// Connecting, selecting database
$link = mysql_connect(localhost, root, mypassword)
or die(Could not connect);
print Connected successfully;
// Performing SQL query
$query = SELECT now();
$result = mysql_query($query)
or die(Query failed);
// Printing results in HTML
print table\n;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print \ttr\n;
foreach ($line as $col_value) {
print \t\ttd$col_value/td\n;
}
print \t/tr\n;
}
print /table\n;
// Closing connection
mysql_close($link);
?
-
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
