MySQL ODBC Connector - Permissions

Author

Permissions

Walter Johnson

2006-02-25, 9:43 am

This is probably a simple question. I installed MySQL about a month ago
on Mac OS X and I am new to this. During the installation (as root) I
created a directory /var/mysql-data. Then, following the installation
instructions:

#chown mysql:mysql /var/mysql-data
#chmod 770 /var/mysql-data

The problem is that I am denied access to all of the databases I have
created - permission denied except when I connect to the server. When I
look in PathFinder, the owner is listed as mysql. NetInfo tells me that
I have such a user, that it is the MySQL server. If I gave mysql a
password, I do not remember it. I did set up a mysql root with
password, and using Navicat I have created another user.

Should I not see my databases in /var/mysql-data either in the terminal
or the Finder?

thanks
-walter

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Dan Trainor

2006-02-25, 9:43 am

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Walter Johnson wrote:
> This is probably a simple question. I installed MySQL about a month ago
> on Mac OS X and I am new to this. During the installation (as root) I
> created a directory /var/mysql-data. Then, following the installation
> instructions:
>
> #chown mysql:mysql /var/mysql-data
> #chmod 770 /var/mysql-data
>
> The problem is that I am denied access to all of the databases I have
> created - permission denied except when I connect to the server. When I
> look in PathFinder, the owner is listed as mysql. NetInfo tells me that
> I have such a user, that it is the MySQL server. If I gave mysql a
> password, I do not remember it. I did set up a mysql root with
> password, and using Navicat I have created another user.
>
> Should I not see my databases in /var/mysql-data either in the terminal
> or the Finder?
>
>
> thanks
> -walter
>

Hi, Walter -

What's the exact error there? We can't tell if you're talking about
file permissions, or actual database permissions.

Thanks
- -dant
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFD/ jq2dJpmX+LLzdoRAovMA
JoCkwx3E2/ yVLrQ3xw7RT4iXkxwHwC
eJIbn
8cXh8IEGpNjnXUGLYBep
zXw=
=MEyX
-----END PGP SIGNATURE-----

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Walter Johnson

2006-02-25, 9:43 am

Dan Trainor wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Walter Johnson wrote:
>
>
> Hi, Walter -
>
> What's the exact error there? We can't tell if you're talking about
> file permissions, or actual database permissions.
>
> Thanks
> - -dant
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.6 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFD/ jq2dJpmX+LLzdoRAovMA
JoCkwx3E2/ yVLrQ3xw7RT4iXkxwHwC
eJIbn
> 8cXh8IEGpNjnXUGLYBep
zXw=
> =MEyX
> -----END PGP SIGNATURE-----
>
>
File permissions.

thanks
-walter

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

CodeHeads

2006-02-25, 9:43 am

--=- JvN43mkVx+AzoTAoUHOh

Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Thu, 2006-02-23 at 21:46 -0600, Walter Johnson wrote:[color=darkred
]

Try this, assuming the files are in there for the database.

$chown -R mysql:mysql /var/mysql-data/*
$chmod -R 770 /var/mysql-data/*

Hope that helps.=20
--=20
Best regards,
~WILL~
Key: http://code-heads.com/keys/ch1.asc=20
Key: http://code-heads.com/keys/ch2.asc=20
Linux Commands: http://code-heads.com/commands=20
Linux Registered User: 406084 (http://counter.li.org/)

--=- JvN43mkVx+AzoTAoUHOh

Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.1 (GNU/Linux)

iD8DBQBD/ oTNfw3TK8jhZrsRAuZTA
J425WT3FquTFnyLrGIji
fqT42eSMgCeMuYH
kyjfZF51DlgN3ob/usYurzI=
=4Ls4
-----END PGP SIGNATURE-----

--=- JvN43mkVx+AzoTAoUHOh
--

Walter Johnson

2006-02-25, 9:44 am

CodeHeads wrote:
> On Thu, 2006-02-23 at 21:46 -0600, Walter Johnson wrote:
>
>
> Try this, assuming the files are in there for the database.
>
> $chown -R mysql:mysql /var/mysql-data/*
> $chmod -R 770 /var/mysql-data/*
>
> Hope that helps.
>
CodeHeads,

Thanks for the suggestion. But, I am still denied access to
/var/mysql-data
and/usr/local/mysql-standard-5.0.18-osx10.4-powerpc/data. I get
'Permission Denied' when I try to change to either directory. The owner
of both is 'mysql'. For /var/mysql-data with PathFinder under Contents,
there is a faint '9' in parentheses, but I cannot see the databases (or
tables and views).

thanks
-walter

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links