; 2012/01/03 11:52 -0500, Govinda
...which strikes me as odd (again, showing how new I am to driving from the
CL), because I do NOT see any entry like this:
/usr/local/mysql/bin/mysqldump
Is mysql a symbolic link?
..which I just (earlier this morning) changed to this:
export
..which I just (earlier this morning) changed to this:
export
PATH=/usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:/usr/local/mysql/bin/mysqldump:$PATH
You are missing a point, that the proper thing for PATH is directory (or
effective directory), not runfile in directory. This,
Jan, thanks so much for taking the time with me.
I hesitate to spend much of everyone's inbox space on this as it is getting off
topic, and I am newbie enough with all things CL that folks will tire of me
before I am near ready to complete the thread.
Like it took me a bit of time to
On 31 Dec 11, at 20:36, Govinda wrote:
If you're using MacOS X Server, it should be in /usr/bin, which should be in
your default $PATH, or else you couldn't do ANYTHING, including ls.
I have notes somewhere in my stuff about how to get $PATH to include where
mysql actually lives, but once
So then I try (in Mac OS X Terminal, while logged in as me (not root)):
mysqldump -uroot -p myDBname myTableName ~/myTestDumpedTable.sql
...and again it produces:
sh: mysqldump: command not found..
that is because Mac OSX is missing a package-managment and so you need
a little knowledge
Am 31.12.2011 23:53, schrieb Jan Steinman:
And for the record, there are at least two excellent package managers
available for Mac OS, and either MacPorts or Fink
if you call this package-managment from the view of a operating
system you have never seen a real one - this are ADDITIONAL
So then I try (in Mac OS X Terminal, while logged in as me (not root)):
mysqldump -uroot -p myDBname myTableName ~/myTestDumpedTable.sql
...and again it produces:
sh: mysqldump: command not found..
that is because Mac OSX is missing a package-managment and so you need
a little knowledge
[snip]
that is because Mac OSX is missing a package-managment and so you need
a little knowledge about your OS to fix the PATH or you have to use
full-qualified calls or configure/install your software to locations
which are already in the path
which mysqldump as normal user wil tell you
Am 29.12.2011 19:21, schrieb Govinda:
Just a side note, that:
Govind% which mysqldump
mysqldump: Command not found.
Govind% which /usr/local/mysql/bin/mysqldump
/usr/local/mysql/bin/mysqldump
kind of defeats the purpose of having to know the path in advance in order
to use the
myTestDumpedTable.sql
..then I keep getting this:
myTestDumpedTable.sql: Permission denied.
Same result if I do any variation on that (try to dump the whole db, drop the
'-p', etc.)
On StackOverflow I asked this question [1], and replies there led me to trying
being logged in as root user
I would suggest trying:
mysqldump -uroot -p myDBname myTableName /tmp/myTestDumpedTable.sql
Maybe you don't have permission (or space) to write into /usr/local/mysql/bin.
That would
be an unusual place for such files.
On 12/29/11 9:15 AM, Govinda wrote:
Hi Everyone
This should be quick
Am 29.12.2011 18:15, schrieb Govinda:
...when I try this:
mysqldump -uroot -p myDBname myTableName myTestDumpedTable.sql
..then I keep getting this:
myTestDumpedTable.sql: Permission denied.
your unix-user has no write permissions to myTestDumpedTable.sql
this has nothing to do wirh
On 02/16/2010 17:30, Zakai Kinan wrote:
I am getting this error - mysqldump: Got error: 1044: Access denied for user
'root'@'localhost' to database 'information_schema' when using LOCK TABLES. I
am using 5.1.45. I don't understand what is causing this problem. Does anyone
have a clue?
Thanks for the answer.
ZK
--- On Wed, 2/17/10, Mikhail Berman mikhail...@gmail.com wrote:
From: Mikhail Berman mikhail...@gmail.com
Subject: Re: Information_schema permission error
To: Zakai Kinan titanyen2...@yahoo.com
Cc: mysql@lists.mysql.com
Date: Wednesday, February 17, 2010, 5:49 AM
I am getting this error - mysqldump: Got error: 1044: Access denied for user
'root'@'localhost' to database 'information_schema' when using LOCK TABLES. I
am using 5.1.45. I don't understand what is causing this problem. Does anyone
have a clue?
TIA,
Zak
--
MySQL General
I'm also having this strange problem just as stated here, anybody find a
fix for this yet?
Again, using wildcards (%) for the Host don't work while the FQDN does
from the exact same remote machine, the exact same username, etc. There
is something about the wildcard ACL that is not working
Would you mind posting what you tried? Did you put single quotes around the
wildcard like '%' ?
For example: GRANT ALL ON somedb.* TO 'someuser'@'%';
Also see http://dev.mysql.com/doc/refman/5.0/en/grant.html
CheersFish
On Sat, Oct 25, 2008 at 1:40 PM, Joe Auty [EMAIL PROTECTED]
Fish Kungfu wrote:
Would you mind posting what you tried? Did you put single quotes around the
wildcard like '%' ?
For example: GRANT ALL ON somedb.* TO 'someuser'@'%';
Also see http://dev.mysql.com/doc/refman/5.0/en/grant.html
CheersFish
Sure!
On what I'll call mynewserver
I think I see the typo. If that's an exact copy paste of your GRANT
statement, then the problem is the spaces in the database designation:
You have: GRANT ALL PRIVILEGES ON * . * TOetc
But it should be: GRANT ALL PRIVILEGES ON *.* TOetc
There shouldn't be any spaces in the *.* part.
I think I see the typo. If that's an exact copy paste of your GRANT
statement, then the problem is the spaces in the database designation:
You have: GRANT ALL PRIVILEGES ON * . * TOetc
But it should be: GRANT ALL PRIVILEGES ON *.* TOetc
There shouldn't be any spaces in the *.* part.
Hmmm, that is strange indeed. Hopefully one of the Level 70+ MySQL Wizards
on the list can explain why this might happen.
~~Fish~~
On Sat, Oct 25, 2008 at 4:44 PM, Joe Auty [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Fish Kungfu wrote:
| I think I see the
Hi all,
I'm receiving an error when trying to invoke a procedure from a
[EMAIL PROTECTED] which is not the definer. I created the procedure with the
statement 'SQL SECURITY INVOKER' but is still not working. Does anyone
know why? The MySQL version is 5.0.36.
Both users [EMAIL PROTECTED]
Yes, I did FLUSH PRIVILEGES and I think I only have one username/host
entry for this user.
Adam
Erik Giberti wrote:
Did you FLUSH PRIVILEGES?
I'd also check that the username and passwords are the same for each
host entry, I've had problems if passwords were different for a shared
username
I set up a user and entered % for the host. I am not able to connect.
However, if I change the host value to my FQDN it works fine. Shouldn't
the wildcard allow me to connect from any host?
Thanks,
Adam
--
Adam Gerson
Assistant Director of Technology
Apple Certified System Administrator
Did you FLUSH PRIVILEGES?
I'd also check that the username and passwords are the same for each
host entry, I've had problems if passwords were different for a shared
username from different hosts.
On Apr 24, 2008, at 8:58 AM, Adam Gerson wrote:
I set up a user and entered % for the host. I
Dear all,
I create a database called test_aaa to a user. And give him
a permission to create and drop on this database. But I found
he can create a database called test-aaa by his own. Can MySQL
identify this problem?
Also, can I limit user can only drop table in test_aaa but CAN NOT
drop
On 3/29/2006 2:10 PM, Jorrit Kronjee wrote:
It seems you are running in to Bug #7209:
http://bugs.mysql.com/bug.php?id=7209
This is fixed in 5.0.19 now.
Best regards
Mark
Mark,
Apparently so, thanks for the hint! We'll try to upgrade as soon as
possible.
I'll supply the mailing
Jorrit Kronjee wrote:
On 3/29/2006 2:10 PM, Jorrit Kronjee wrote
Mark,
Apparently so, thanks for the hint! We'll try to upgrade as soon as
possible.
I'll supply the mailing list with the results of the upgrade.
Mark,
We've been testing it over the weekend and it seems that the bugs
[EMAIL PROTECTED] wrote:
is this relevant ?
We've been looking at connection graphs, but MySQL doesn't seem to reach
that limit. However, these are timely based measurements, so it could've
peaked in between, although highly unlikely.
I'm not very comfortable tweaking these values in a
Hi Jorrit,
Jorrit Kronjee wrote:
[EMAIL PROTECTED] wrote:
is this relevant ?
We've been looking at connection graphs, but MySQL doesn't seem to
reach that limit. However, these are timely based measurements, so it
could've peaked in between, although highly unlikely.
I'm not very
Mark Leith wrote:
Hi Jorrit,
Jorrit Kronjee wrote:
[EMAIL PROTECTED] wrote:
is this relevant ?
We've been looking at connection graphs, but MySQL doesn't seem to
reach that limit. However, these are timely based measurements, so it
could've peaked in between, although highly unlikely.
Hello list,
Recently we upgraded from 3.23.3 to 5.0.18 and started noticing some
weird behaviour. We have update scripts running on a regular interval
and some of these scripts randomily exited with MySQL error:
SELECT command denied to user 'user'@'host' for table 'example'
However, this error
[EMAIL PROTECTED]
Subject: Random 'select permission denied' since upgrade to 5.0.18
Hello list,
Recently we upgraded from 3.23.3 to 5.0.18 and started noticing some
weird behaviour. We have update scripts running on a regular interval
and some of these scripts randomily exited with MySQL error
On Tue, 28 Mar 2006, Jorrit Kronjee wrote:
To: mysql@lists.mysql.com
From: Jorrit Kronjee [EMAIL PROTECTED]
Subject: Re: Random 'select permission denied' since upgrade to 5.0.18
snip
Could this message appear when, for instance, a maximum amount of threads
has been spawned or MySQL has
[EMAIL PROTECTED] wrote:
On Tue, 28 Mar 2006, Jorrit Kronjee wrote:
To: mysql@lists.mysql.com
From: Jorrit Kronjee [EMAIL PROTECTED]
Subject: Re: Random 'select permission denied' since upgrade to 5.0.18
snip
Could this message appear when, for instance, a maximum amount of threads
has been
is your access control by hostname or IPnumber? if hostname you could
be having transient DNS issues - where the IPnumber on the client
connect can't be resolved into the permitted hostname (fast enough).
try using IPnumber in the access control and see if the problem goes
away - if it does
On Tue, 28 Mar 2006, Jorrit Kronjee wrote:
To: mysql@lists.mysql.com
From: Jorrit Kronjee [EMAIL PROTECTED]
Subject: Re: Random 'select permission denied' since upgrade to 5.0.18
[EMAIL PROTECTED] wrote:
On Tue, 28 Mar 2006, Jorrit Kronjee wrote:
To: mysql@lists.mysql.com
From
original-
De: unplug [mailto:[EMAIL PROTECTED]
Enviado el: martes, 28 de febrero de 2006 21:55
Para: mysql@lists.mysql.com
Asunto: file permission
Hi,
When I use a query SELECT * into outfile '/tmp/report.csv' fields terminated
by ',' lines terminated by '\n' FROM table;, it will create
[snip]
This function is great! Anyone know how to include the column names, table
info, any extra miscellaneous info? I use SQLyog for exporting to csv and they
do include the columns, my bet is its some SQL option. The manual doesn't
specify, at least in the select syntax part.
[/snip]
Any
... But I though there was a -include_column_names
option or something :)
Which way should I go?
Ariel
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 01 de marzo de 2006 10:58
Para: Ariel Sánchez Mora; mysql@lists.mysql.com
Asunto: RE: file permission
I finally ended up removing and installing back my mysql since i have
to success retrieving my mysql root password.
Now I am putting my databases back. It shows an error something that
it couldn't write unto file already exists. What I did I change the
permission of the directory like
Hi,
When I use a query SELECT * into outfile '/tmp/report.csv' fields
terminated by ',' lines terminated by '\n' FROM table;, it will
create a file with the following permission and owner.
-rw-rw-rw- 1 mysql mysql 2489 Mar 1 11:30 report.csv
How can I change the default permission
On Tuesday 28 February 2006 22:55, unplug wrote:
Hi,
When I use a query SELECT * into outfile '/tmp/report.csv' fields
terminated by ',' lines terminated by '\n' FROM table;, it will
create a file with the following permission and owner.
-rw-rw-rw- 1 mysql mysql 2489 Mar 1 11:30
Thanks!
But I want to change the default setting of the file permission and
ownership. (i.e. the file will be created with permission and
ownerhsip according to my setting).
On 3/1/06, CodeHeads [EMAIL PROTECTED] wrote:
On Tuesday 28 February 2006 22:55, unplug wrote:
Hi,
When I use a query
as the
user you want to own the file and outputing the results via the script.
j- k-
On Tuesday 28 February 2006 19:18, unplug wrote:
Thanks!
But I want to change the default setting of the file permission and
ownership. (i.e. the file will be created with permission and
ownerhsip
On Tuesday 28 February 2006 23:41, Joshua Kugler wrote:
You can't do that. The mysql server runs as user mysql, so it cannot
create files owned by another user. If you run the mysql server as root
(don't!), you might be able to do that, but I do not believe mysql has a
facility for changing
permission and ownership
will be created.
-rw-rw-rw- 1 mysql mysql 2489 Mar 1 11:30 report.csv
In the seconde run, the script will failed as user A have no
permission to remove the file.
In order to run the script daily, ownership of the file should be
changed to user A.
On 3/1/06, CodeHeads
Hello.
Please, next time always CC your messages to the list as well. I'm
not a lampp expert and can only point you to:
http://dev.mysql.com/doc/refman/5.0/en/program-options.html
This advice proved very helpful. This is where its at now:
I noticed that the .err file belonged to user
[Sorry] I didn't realize that hitting Reply (using Gmail) sent a
private message. Usually on lists the message ends up on the list.
Will need to observe the header in the future.
tx;
-nat
On 1/27/06, Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
Please, next time always CC your messages to
directroy structure, with
the owner now being mysql with full rights.
I do not know at which point this happened but I can't bring up the
thing any longer. This is what I get:
060124 14:15:44 mysqld started
060124 14:15:44 [ERROR] Can't start server : Bind on unix socket:
Permission denied
, with
the owner now being mysql with full rights.
I do not know at which point this happened but I can't bring up the
thing any longer. This is what I get:
060124 14:15:44 mysqld started
060124 14:15:44 [ERROR] Can't start server : Bind on unix socket:
Permission denied
060124 14:15:44 [ERROR] Do you
on procedure test_procedure to '%'@localhost;
-Messaggio originale-
Da: AESYS S.p.A. [Enzo Arlati] [mailto:[EMAIL PROTECTED]
Inviato: venerdì 18 novembre 2005 14.37
A: mysql@lists.mysql.com
Oggetto: setup permission for stored procedure on mysql 5
If I defined I stored procedure as root I
try to grant the execute permission to other users I got an error like
this:
mysql grant execute on test_root to '%'@localhost;
ERROR 1144 (42000): Illegal GRANT/REVOKE command; please consult the manual
to s
ee which privileges can be used
The only way to get stored procedure working is to create
Hi,
I've got the exact same problem than Johannes with MySQL 4.1.14.
Like him, i've set a little script
[EMAIL PROTECTED]($host,$user$password);
while ($i5) {
$x=mysql_query($query);
if ( $x) {
print $i worked!BR;
} else {
print $i ERROR! .mysql_error().BR;
}
$i++;
}
I am having a very odd issue with one of my mysql 4.1.14 servers.
Randomly, the server returns permission denied to queries even if
identical queries succeeded within the same connection.
To test the problem, I setup a script that connects to the database, and
issues the same query 50,000 times
a very odd issue with one of my mysql 4.1.14 servers.
Randomly, the server returns permission denied to queries even if
identical queries succeeded within the same connection.
To test the problem, I setup a script that connects to the database, and
issues the same query 50,000 times. Out
sheeri kritzer wrote:
What is max_connections set to (my.cnf?)? How many connections are
there at a time? (show processlist) That would result in a too many
connections error, but it's worth a shot.
Max connections: 2000
typically 10-20 used (hardly ever 100).
What is the thread cache set
I'm not sure if this will help you, but it might:
http://jeremy.zawodny.com/blog/archives/000173.html
(brief excerpt)
So the moral of the story is this: If you have a busy server that's
getting a lot of quick connections, set your thread cache high enough
that the Threads_created value in SHOW
Hi list readers,
I'm experiencing some strange problems with MySQL 4.1.14. I have a script that
is run as a cronjob in five minute intervals. The script initiates a database
connection and executes certain SQL commands. Sometimes, but not regularly, the
server gives access denied error. If I
Hello.
See:
http://dev.mysql.com/doc/mysql/en/access-denied.html
Ville Mattila [EMAIL PROTECTED] wrote:
Hi list readers,
I'm experiencing some strange problems with MySQL 4.1.14. I have a script
that is run as a cronjob in five minute intervals. The script initiates a
'@'localhost'
There is no permission to update column2, but the user can do so.
What can I do? I use MySQL 4.0.3-beta-nt. Perhaps this version is too old?
(In http://dev.mysql.com/doc/mysql/en/show-grants.html there is an
evidence.)
To the answer from Jigal: When I delete Column_priv: update
TO 'user1'@'localhost'
GRANT UPDATE (column1) ON database1.table1 TO 'user1'@'localhost'
There is no permission to update column2, but the user can do so.
What can I do? I use MySQL 4.0.3-beta-nt. Perhaps this version is too old?
(In http://dev.mysql.com/doc/mysql/en/show-grants.html
ON *.* TO
'user1'@'localhost' IDENTIFIED BY PASSWORD '08862e71234184bc'
GRANT UPDATE (column1) ON database1.table1 TO 'user1'@'localhost'
GRANT UPDATE (column1) ON database1.table1 TO 'user1'@'localhost'
There is no permission to update column2, but the user can do so.
What can I do? I use MySQL 4.0.3
Hello,
I want one of my MySQL-users only update one of my columns in a table. I
used
grant UPDATE (column1) on database1.table1 to 'user1'@'localhost'
but the user1 can update other culumns too.
The mysql-db-table entries for user1 after grant command are:
- db: -
- host: -
- user: Select_priv:
From: Wolfgang Gliese
- db: -
- host: -
- user: Select_priv: Y
- tables_priv: Table_name: table1; Table_priv: - ; Column_priv: Update
- columns_priv: Table_name: table1; Column_name: column1; Column_priv:
Update
What can I do?
I think you'd better reset the column_priv: Update in the
Hello.
Use SHOW GRANTS statement to see all permissions which user has
and revoke unnecessary. See:
http://dev.mysql.com/doc/mysql/en/show-grants.html
http://dev.mysql.com/doc/mysql/en/grant.html
Wolfgang Gliese [EMAIL PROTECTED] wrote:
Hello,
I want one of my MySQL-users
:
mysqld_safe --basedir=/data/mysql --datadir=/data/mysql/mysqldata
--user=mysql
and I still get following error:
Starting mysqld-max daemon with databases from /data/mysql/mysqldata
/usr/bin/mysqld_safe: line 307: /data/mysql/mysqldata/linux.err: Permission
denied
/usr/bin/mysqld_safe: line 313: /data
/mysqld_safe: line 307: /var/lib/mysql/linux.err: Permission denied
/usr/bin/mysqld_safe: line 313: /var/lib/mysql/linux.err: Permission denied
STOPPING server from pid file /var/lib/mysql/linux.pid
tee: /var/lib/mysql/linux.err: Permission denied
050306 03:33:03 mysqld ended
tee: /var/lib/mysql/linux.err
/mysqld_safe: line 307: /var/lib/mysql/linux.err: Permission denied
/usr/bin/mysqld_safe: line 313: /var/lib/mysql/linux.err: Permission denied
STOPPING server from pid file /var/lib/mysql/linux.pid
tee: /var/lib/mysql/linux.err: Permission denied
050306 03:33:03 mysqld ended
tee: /var/lib/mysql
-4.1.9-pc-linux-gnu-i686]# ./INSTALL-BINARY
-bash: ./INSTALL-BINARY: Permission denied
What am I doing wrong here.? I'm rather new to Linux too. Cheers.
Mark Sargent.
Hi Mark,
the file INSTALL-BINARY is a text file that includes documentation
you have to read to know how you should proceed
-BINARY
-bash: ./INSTALL-BINARY: Permission denied
What am I doing wrong here.? I'm rather new to Linux too. Cheers.
Mark Sargent.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
SHOW GRANTS FOR CURRENT_USER();
Law Poop [EMAIL PROTECTED] wrote:
Can a user see their own permissions for a database?
I'm working on a PHP project that will hopefully automagically
generate forms based on a user's permissions. Do I have to create a
seperate account to
That syntax only works in 4.1.2 and up, however. Prior versions only take a
string for the user, not a function call or variable. In that case, you can
find out who you are with
SELECT CURRENT_USER();
+-+
| CURRENT_USER() |
+-+
| [EMAIL PROTECTED]
Can a user see their own permissions for a database?
I'm working on a PHP project that will hopefully automagically
generate forms based on a user's permissions. Do I have to create a
seperate account to find out what a particular user's permissions are,
or is there some way to read permissions
Hi all,
I have a need to use a kind of user permission system in the database,
but because the database is a hosted solution, I do not have access to
the real user tables and permissions and such.
SO...
What we're talking about is a document management system:
1. Some users can read, write
Hello,
My ISP is using the old version 4.0.15a and have no early plans to upgrade it.
I'm trying to issue LOCK/UNLOCK TABLES commands at my ISP's MySQL, and I'm getting an
access denied error.
I asked them to give me the lock tables permission, but they answered this permission
option isn't
at my ISP's MySQL, and I'm getting an
access denied error.
I asked them to give me the lock tables permission, but they answered this permission
option isn't available on versions prior to 4.0.2. They also told me they would have to
give me a high elevated previledge to issue these commands.
Is it true
Fernando Monteiro wrote:
Hello, Michael,
Version 4.0.15 comes after version 4.0.2 (15 2), so the version is
not a problem here.
(...)
I asked them to give me the lock tables permission, but they
answered this permission
option isn't available on versions prior to 4.0.2. They also told me
Dear Victoria Reznichenko,
Thanks for reply.
Could you tell me from where I can get patch to fix
this bug.
or I have to use Mysql 4.0/Mysql 5.0
with regards,
Udbhav Shah
=
Thinking is the Assets
Enterprise is the Way
Hard Work is the Solution
- Ignited Minds
Udbhav Shah [EMAIL PROTECTED] wrote:
Dear Victoria Reznichenko,
Thanks for reply.
Could you tell me from where I can get patch to fix
this bug.
or I have to use Mysql 4.0/Mysql 5.0
You can install latest available version, including the bugfix, from the development
source tree:
Udbhav Shah [EMAIL PROTECTED] wrote:
Using Mysql 4.1.1-alpha release on RH9,
I have used RPM provided on Mysql site to upgrade from
3.23 to 4.1.1
I have a very strange behavior of mysql server,when I
restart my server, it is not reading permission given
to user at Table Level from
Permission
Udbhav Shah [EMAIL PROTECTED] wrote:
Using Mysql 4.1.1-alpha release on RH9,
I have used RPM provided on Mysql site to upgrade from
3.23 to 4.1.1
I have a very strange behavior of mysql server,when I
restart my server, it is not reading permission given
to user at Table Level from
Terence [EMAIL PROTECTED] wrote:
Will be fixed in 4.1.2?
Yes, it's fixed in 4.1.2.
When can we expect that to be out? Anyone with an
idea?
Soon. Probably in two weeks.
- Original Message ---
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
Hello Everyone,
Using Mysql 4.1.1-alpha release on RH9,
I have used RPM provided on Mysql site to upgrade from
3.23 to 4.1.1
I have a very strange behavior of mysql server,when I
restart my server, it is not reading permission given
to user at Table Level from tables_priv.
Permission are still
Installing 4.0.18 on a Mac OS X 10.3.3 system
creates the data directory and its contents
as owned by root instead of mysql.
I tried blowing away the data/mysql directory and
running scripts/mysql_install_db. I tried logging
in as root and doing a recursive chown. Finally
I deleted everything,
I'm not sure how much help I'll be since I have never had a problem
running MySQL on OSX in the two years I have been using it on OSX.
First, you should not need to use sudo or the root account for anything
you do with MySQL except maybe installing it.
Second, I would always specify the account
I am having a problem with accessing the mysql database in a new MySQL
installation on OS X Panther.
This installation came with the original OS, and some configuration was done
right after installation. I have previously installed MySQL on Linux and Win
and have never encountered this problem.
I'm trying to open mysql.sock file as a ROOT and receive the error message
permission denied.
Why mysql.sock has such permission?
_
Tired of slow downloads? Compare online deals from your local high-speed
providers now. https
yeah, if its owned by mysql with no write privs. That doesn't mean you cant change it
using root..
I'm trying to open mysql.sock file as a ROOT and receive the
error message
permission denied.
Why mysql.sock has such permission?
--
MySQL General Mailing List
For list archives: http
I just installed the server and I am getting this
message in the mysql.log when I execute:
./bin/safe_mysqld --user=mysql
Thanks in Advance.
Alex-
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
On Mon, 22 Dec 2003, Aleksei Wolff wrote:
I just installed the server and I am getting this
message in the mysql.log when I execute:
./bin/safe_mysqld --user=mysql
Hi Alex,
You might want to check the permissions of your /tmp directory. Is it
drwxrwxrwt? :)
Regards,
Tan Shao Yi
--
MySQL
Dear lists,
How do I assign user and password to a database that i just created ?
Thanks
';
Are useful basic information in the MySQL documentation. Read this once at
least.
Regards
Thierno6C - MySQL 4.0.15
- Original Message -
From: ketvin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 10, 2003 8:37 AM
Subject: database permission
Dear lists,
How do I assign user
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thierno, et al --
...and then Thierno Cissé said...
%
% Hi Ketvin,
% after you created your database kelvin_db for example,
% you can set a account to use this database in this manner :
% GRANT ALL PRIVILEGES ON user_name.* TO @localhost identified
Hey folks -
I have an installation of mysql 3.23 from debian stable, installed with apt-get.
I'm trying to create users but I'm running into problems. I'm using phpmyadmin, and
myabe that's the problem, I don't know. Here's something that confuses me:
$ mysql -uanna -p
Enter password:
Welcome
query your use table and see if the anonymous user is still present. You
will need to delete this account and flush privileges.
-Original Message-
From: Steven Lefevre [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 11:33 AM
To: [EMAIL PROTECTED]
Subject: Stupid permission
Tore Bostrup [EMAIL PROTECTED] wrote:
MySQL 3.23.36 (yeah, I know it's getting old...):
What permission do I need to run the following query:
REVOKE ALL
ON mydb.* FROM 'sdaf'@'%';
I get an error 1044:
Access denied for user: 'Admin@IP address' to database 'mydb'
My user has GRANT
MySQL 3.23.36 (yeah, I know it's getting old...):
What permission do I need to run the following query:
REVOKE ALL
ON mydb.* FROM 'sdaf'@'%';
I get an error 1044:
Access denied for user: 'Admin@IP address' to database 'mydb'
My user has GRANT permission on mydb (database) and GRANT
Why do I get a permission denied when I try to execute the following SQL statement via
ODBC 3.51?
UPDATE mysql.user SET Password = Password('Blank') WHERE user = 'sdaf'
I can execute the statement from a tool such as SQLYog (logged in as 'myAdmin').
The error I get is:
DIAG [S1000
such as SQLyog.
Is this possible that one tool has the permission and
another not?
karam
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
1 - 100 of 170 matches
Mail list logo