Re: newbie installation question
Machine (operating system) rights and database rights are two, very separate, permissions systems. MySQL maintains it's own access control lists, separate and distinct, from your operating system. You cannot see any other tables when you use your database tool because you are authenticating to the database using an underprivileged login. By default, a new installation (or a clean re-installation, like yours) of MySQL has an administrative login "root" that has no password. Try using that account next time you connect with "mysqlshow" and you will have full privileges. It is one of the first administrative tasks of a new installation is to reset the root password to something (anything) to close that security loophole. Here is some background reading on the issues: http://dev.mysql.com/doc/mysql/en/Post-installation.html http://dev.mysql.com/doc/mysql/en/Default_privileges.html http://dev.mysql.com/doc/mysql/en/Privilege_system.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Morten Pedersen" <[EMAIL PROTECTED]> wrote on 09/29/2004 05:36:54 AM: > > sorry for spamming the list with this, i tried asking on the forums, > but didn't receive a reply. i'm a complete newbie to mysql/php, but > have programmed professionally (in C/C++/ASM) for about 9 years now. > > i originally installed mysql into C:/Program Files/mysql, before > deleting and reinstalling in the default subdirectory, which meant > some paths in the registry had been setup incorrectly. i changed > these manually (2 of them located), and this fixed a few issues. > > however after reinstalling, when i do a mysqlshow, it shows only > "test" in the list of available databases, and nothing i seem to > change makes a difference. i edited the my.ini to the base+base/data > directories, but that didn't change anything. i even tried changing > the paths in my.ini to invalid paths, and that didn't change > anything either (it still located test, and test only). > > i searched for a test subdirectory elsewhere on my hard drive, but > failed to locate one. i then created a new database, which it did in > the correct subdirectory, so since it seems to be writing to the > correct subdirectory, why on earth doesn't it read from the directory as well? > > i have administrator access to the machine. > > any help is much appreciated, cheers.
newbie installation question
sorry for spamming the list with this, i tried asking on the forums, but didn't receive a reply. i'm a complete newbie to mysql/php, but have programmed professionally (in C/C++/ASM) for about 9 years now. i originally installed mysql into C:/Program Files/mysql, before deleting and reinstalling in the default subdirectory, which meant some paths in the registry had been setup incorrectly. i changed these manually (2 of them located), and this fixed a few issues. however after reinstalling, when i do a mysqlshow, it shows only "test" in the list of available databases, and nothing i seem to change makes a difference. i edited the my.ini to the base+base/data directories, but that didn't change anything. i even tried changing the paths in my.ini to invalid paths, and that didn't change anything either (it still located test, and test only). i searched for a test subdirectory elsewhere on my hard drive, but failed to locate one. i then created a new database, which it did in the correct subdirectory, so since it seems to be writing to the correct subdirectory, why on earth doesn't it read from the directory as well? i have administrator access to the machine. any help is much appreciated, cheers.
Re: Installation Question
I second Ugo's opinion. dan Ugo Bellavance wrote: -Message d'origine- De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Envoyé : Thursday, January 01, 2004 12:16 PM À : '[EMAIL PROTECTED]' Objet : RE: Installation Question Dan: Thank you fast reply on New Year Day. The only reason I was trying to install the source distribution because it is supposed to be optimized!! It is not optimized. It is optimizeable, not the same thing. However, you need to know exacly what are the compiler flags to optimize it. If you run on x86, you are better of with the binary or the .rpm. No offense, but people who compile at mysql are a lot better than you and me to get the best flags. hth Ugo Is binary distribution is also optimized or it makes no difference? I personally prefer binary myself. I will wait for a response before I start all over again. Thanks again. Kirti -Original Message- From: dan orlic [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 12:07 PM To: Kirti S. Bajwa Subject: Re: Installation Question i never had much luck with the source distribution, let alone using the prefix flag. Try untarring it in /usr/local/mysql dir yourself and then continue with the ./configure make and so forth... better yet, i would untar it in a /usr/local/mysql-whatever-version and then make a soft link of mysql point to that directory, allows you to have multiple installs of mysql where all you have to change is the link and restart mysql. my humble option, go with the binary installation it will take you less then a couple minutes to install. hope this helps. dan Kirti S. Bajwa wrote: I am trying to install MySQL from source distribution by following the instructions under section: 2.3.1 Quick Source Installation Overview. I notice that the configure state is listed as follows: shell> ./configure --prefix=/usr/local/mysql which means to install the software in /usr/local/mysql. After I run this configure statement, I do not see a folder /usr/local/mysql!! Is it correct? Kirti -- 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]
RE: Installation Question
> -Message d'origine- > De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED] > Envoyé : Thursday, January 01, 2004 12:16 PM > À : '[EMAIL PROTECTED]' > Objet : RE: Installation Question > > > > Dan: > > Thank you fast reply on New Year Day. > > The only reason I was trying to install the source > distribution because it > is supposed to be optimized!! It is not optimized. It is optimizeable, not the same thing. However, you need to know exacly what are the compiler flags to optimize it. If you run on x86, you are better of with the binary or the .rpm. No offense, but people who compile at mysql are a lot better than you and me to get the best flags. hth Ugo > > Is binary distribution is also optimized or it makes no difference? I > personally prefer binary myself. I will wait for a response > before I start > all over again. > > Thanks again. > > > Kirti > > > -Original Message- > From: dan orlic [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 01, 2004 12:07 PM > To: Kirti S. Bajwa > Subject: Re: Installation Question > > > i never had much luck with the source distribution, let alone > using the > prefix flag. Try untarring it in /usr/local/mysql dir > yourself and then > continue with the ./configure make and so forth... better > yet, i would > untar it in a /usr/local/mysql-whatever-version and then make a soft > link of mysql point to that directory, allows you to have multiple > installs of mysql where all you have to change is the link > and restart > mysql. my humble option, go with the binary installation it will > take you less then a couple minutes to install. > > hope this helps. > > dan > > Kirti S. Bajwa wrote: > > >I am trying to install MySQL from source distribution by > following the > >instructions under section: 2.3.1 Quick Source Installation > Overview. > >I notice that the configure state is listed as follows: > >shell> ./configure --prefix=/usr/local/mysql > > > >which means to install the software in /usr/local/mysql. > After I run this > >configure statement, I do not see a folder /usr/local/mysql!! Is it > correct? > > > >Kirti > > > > > > > > > > > -- > 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]
RE: Installation Question
Dan: Thank you fast reply on New Year Day. The only reason I was trying to install the source distribution because it is supposed to be optimized!! Is binary distribution is also optimized or it makes no difference? I personally prefer binary myself. I will wait for a response before I start all over again. Thanks again. Kirti -Original Message- From: dan orlic [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 12:07 PM To: Kirti S. Bajwa Subject: Re: Installation Question i never had much luck with the source distribution, let alone using the prefix flag. Try untarring it in /usr/local/mysql dir yourself and then continue with the ./configure make and so forth... better yet, i would untar it in a /usr/local/mysql-whatever-version and then make a soft link of mysql point to that directory, allows you to have multiple installs of mysql where all you have to change is the link and restart mysql. my humble option, go with the binary installation it will take you less then a couple minutes to install. hope this helps. dan Kirti S. Bajwa wrote: >I am trying to install MySQL from source distribution by following the >instructions under section: 2.3.1 Quick Source Installation Overview. >I notice that the configure state is listed as follows: >shell> ./configure --prefix=/usr/local/mysql > >which means to install the software in /usr/local/mysql. After I run this >configure statement, I do not see a folder /usr/local/mysql!! Is it correct? > >Kirti > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation Question
I am trying to install MySQL from source distribution by following the instructions under section: 2.3.1 Quick Source Installation Overview. I notice that the configure state is listed as follows: shell> ./configure --prefix=/usr/local/mysql which means to install the software in /usr/local/mysql. After I run this configure statement, I do not see a folder /usr/local/mysql!! Is it correct? Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation Question - RedHat 9.0
For RedHat, just download the rpms and install it, it's far much simpler... Nicolas - Original Message - From: "Ryan Sinnwell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 16, 2003 1:21 PM Subject: Installation Question - RedHat 9.0 I am trying to setup Jabberd2 as a test for our IT users and have run into a few issues. Here is a link to the instructions I'm following: http://www.jabberdoc.org/app_mysql.html I know there are things missing because after I complete the "make install" in step A.4.6, it goes right on to have me change the root password, but mysqld isn't even running at this point. Could someone that has installed mySQL many times give these a look and see what steps they have left out that I will need for RedHat 9.0? One other step that doesn't appear to be correct is A.4.9 because /usr/local/var/mysql/ does not even exist after the install as they describe it. Also, if I want mysqld to start every time the computer is booted, and use the mysql user that I created per these instructions, is this what I would add to rc.local: /usr/local/libexec/mysqld --user=mysql & Is rc.local the correct file to put this in or is there a better place? Any help that is provided will be much appreciated. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation Question - RedHat 9.0
I am trying to setup Jabberd2 as a test for our IT users and have run into a few issues. Here is a link to the instructions I'm following: http://www.jabberdoc.org/app_mysql.html I know there are things missing because after I complete the "make install" in step A.4.6, it goes right on to have me change the root password, but mysqld isn't even running at this point. Could someone that has installed mySQL many times give these a look and see what steps they have left out that I will need for RedHat 9.0? One other step that doesn't appear to be correct is A.4.9 because /usr/local/var/mysql/ does not even exist after the install as they describe it. Also, if I want mysqld to start every time the computer is booted, and use the mysql user that I created per these instructions, is this what I would add to rc.local: /usr/local/libexec/mysqld --user=mysql & Is rc.local the correct file to put this in or is there a better place? Any help that is provided will be much appreciated. Thanks! Ryan Sinnwell Regional IT Engineer The Weitz Company 515-698-4281 515-229-5517 (Cell) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: installation question...missing 'host.frm'
Errno 13 indicates that you have some permission issues. Check the data directories you've set up to make sure that they are owned by the user/group mysql. Thank you. That was the problem. The "host.frm" really threw me. Craig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: installation question...missing 'host.frm'
Craig, Errno 13 indicates that you have some permission issues. Check the data directories you've set up to make sure that they are owned by the user/group mysql. -Original Message- From: Craig A. Finseth [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:42 PM To: [EMAIL PROTECTED] Subject: installation question...missing 'host.frm' I am trying to install: mysql-standard-4.0.14-sun-solaris2.8-sparc.tar on a Solaris 8 system. I am getting this message in the .err file: 030910 11:05:41 mysqld started 030910 11:05:41 InnoDB: Started 030910 11:05:41 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 030910 11:05:41 Aborting I haven't been able to find any reference to that file in any of the MySQL documentation. I've tried creating such a file, but the message remains unchanged. I am doing a little weird install. The commands and scripts go into /usr/local/bin and the database lives in /local/mysql. I have added symbolic cross links. Anyone have any ideas? Craig A. Finseth[EMAIL PROTECTED] Firwood Consulting, Inc.[EMAIL PROTECTED] 1343 Lafond, St Paul MN 55104 +1 651 644 4027 USA http://www.firwood.net +1 651 644 4027 fax (yes, same number) A ship is safe in a harbor, but that's not what a ship is for--Adm Grace Hopper -- 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]
installation question...missing 'host.frm'
I am trying to install: mysql-standard-4.0.14-sun-solaris2.8-sparc.tar on a Solaris 8 system. I am getting this message in the .err file: 030910 11:05:41 mysqld started 030910 11:05:41 InnoDB: Started 030910 11:05:41 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 030910 11:05:41 Aborting I haven't been able to find any reference to that file in any of the MySQL documentation. I've tried creating such a file, but the message remains unchanged. I am doing a little weird install. The commands and scripts go into /usr/local/bin and the database lives in /local/mysql. I have added symbolic cross links. Anyone have any ideas? Craig A. Finseth[EMAIL PROTECTED] Firwood Consulting, Inc.[EMAIL PROTECTED] 1343 Lafond, St Paul MN 55104 +1 651 644 4027 USA http://www.firwood.net +1 651 644 4027 fax (yes, same number) A ship is safe in a harbor, but that's not what a ship is for--Adm Grace Hopper -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Newbie Installation Question
When executing from the COMMAND PROMPT, the following is returned: C:\>cd mysql C:\mysql>cd bin C:\mysql\bin>mysqlshow -u Administrator --password=1234567890 mysql Database: mysql +--+ | Tables | +--+ | columns_priv | | db | | func | | host | | tables_priv | | user | +--+ C:\mysql\bin> When using the MYSQL CONTROL CENTER, the following is returned. [Default] ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I've trying reading the manual, and I don't have the privileges to change the System or User Administration Tables. Does anyone have a fix in the WIN 2000 Server environment? David M Friscia friscia.rootsweb.com [EMAIL PROTECTED]
Re: MySQL newbie installation question
CM Miller wrote: Very new to MySQL and I've done a search on google.com, but really couldn't find the answer that I am looking for. Where should I install MySQL? I'm running RH 7.3 and I've installed the tgz file under my directory /home/CMMiller, is this right, or anywhere else? I see it is also under /usr/share. Do as the readme says - unpack the distribution and follow instructions. Standard location for mysql distribution is /usr/local/mysql from which you should make symlinks to /usr/loca/bin etc. You can put your data files pretty much everywhere but be very careful about permissions (some directories should be wriable by root only, some has to be writable by mysql user - read error nessages if in doubt and pay attention to security issues). Test your setup by starting the daemon manually specifying installation directory, data directory and user (-u mysql). Then put a service file in /etc/init.d and make symlinks to appropriate /etc/rc.d directories. how do I login once I get it up and going, or change passwords, or do basic admin work? There is a text client called 'mysql' :-) Check it out. HTH, Max - 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 newbie installation question
Very new to MySQL and I've done a search on google.com, but really couldn't find the answer that I am looking for. Where should I install MySQL? I'm running RH 7.3 and I've installed the tgz file under my directory /home/CMMiller, is this right, or anywhere else? I see it is also under /usr/share. Another thing, I can either start the server from /etc/rc.d/init.d/ or /usr/share, but how do I login once I get it up and going, or change passwords, or do basic admin work? thanks -Chris = * GAIM ID: cmmiller1973 * __ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com - 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: RPM Installation Question
Excellent info... thanks... (a little late response, but there was no net access in the woods... :P) Thanks again! --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata RedHat Engineer - RHCE # 807302349405893 Cisco Certified - CCNA # CSCO10151622 [EMAIL PROTECTED] --- "I love deadlines. I especially like the whooshing sound they make as they go flying by." -- Douglas Adams [1952-2001] -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 1:01 PM To: MYSQL-List (E-mail) Subject: RE: RPM Installation Question read the documentation in the my.cnf sections you can supply datadir=/usr/data/mysql (or whatever the data directory you choose) make sure mysql has permissions on the new directory a couple other things rely on this base directory too your socket file your pid file You can set these too in your /etc/my.cnf pid-file=/usr/data/mysql/mysql.pid socket=/tmp/mysql.sock or some such directories Your err files will write to the datadir you specify > -Original Message- > From: Jason Frisvold [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 01, 2002 11:25 AM > To: [EMAIL PROTECTED] > Subject: RPM Installation Question > > > I was hoping to use the RPM distribution to install MySQL on > my Linux machine. However, I notice that it sets the data > directory to /var/lib/mysql ... This is unacceptable for my > purposes... I know I can probably use a link to fix this, > but I'd rather do it the "right" way... How do I tell mySQL > where the data directory is? Is this a compiled option? > > Thanks, > > --- > Jason H. Frisvold > Senior ATM Engineer > Engineering Dept. > Penteledata > RedHat Engineer - RHCE # 807302349405893 > Cisco Certified - CCNA # CSCO10151622 > [EMAIL PROTECTED] > --- > "Imagination is more important than knowledge. Knowledge is > limited. Imagination encircles the world." -- Albert Einstein > [1879-1955] > > > - > 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
RE: RPM Installation Question
read the documentation in the my.cnf sections you can supply datadir=/usr/data/mysql (or whatever the data directory you choose) make sure mysql has permissions on the new directory a couple other things rely on this base directory too your socket file your pid file You can set these too in your /etc/my.cnf pid-file=/usr/data/mysql/mysql.pid socket=/tmp/mysql.sock or some such directories Your err files will write to the datadir you specify > -Original Message- > From: Jason Frisvold [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 01, 2002 11:25 AM > To: [EMAIL PROTECTED] > Subject: RPM Installation Question > > > I was hoping to use the RPM distribution to install MySQL on > my Linux machine. However, I notice that it sets the data > directory to /var/lib/mysql ... This is unacceptable for my > purposes... I know I can probably use a link to fix this, > but I'd rather do it the "right" way... How do I tell mySQL > where the data directory is? Is this a compiled option? > > Thanks, > > --- > Jason H. Frisvold > Senior ATM Engineer > Engineering Dept. > Penteledata > RedHat Engineer - RHCE # 807302349405893 > Cisco Certified - CCNA # CSCO10151622 > [EMAIL PROTECTED] > --- > "Imagination is more important than knowledge. Knowledge is > limited. Imagination encircles the world." -- Albert Einstein > [1879-1955] > > > - > 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
RPM Installation Question
I was hoping to use the RPM distribution to install MySQL on my Linux machine. However, I notice that it sets the data directory to /var/lib/mysql ... This is unacceptable for my purposes... I know I can probably use a link to fix this, but I'd rather do it the "right" way... How do I tell mySQL where the data directory is? Is this a compiled option? Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata RedHat Engineer - RHCE # 807302349405893 Cisco Certified - CCNA # CSCO10151622 [EMAIL PROTECTED] --- "Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." -- Albert Einstein [1879-1955] - 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
Installation question
Would I get better performance if mysql were being run from a SCSI hard drive? Lawrence - 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
installation question
Hi After i install mysql, there is a way that i can know on witch drive i installed it on? - 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: Installation question
Muriel, Friday, April 26, 2002, 1:14:02 AM, you wrote: M> My ISP installed MYSQL -max-3.23.49a-pclinux-gnu-i686 on our M> dedicated server. They discovered they did not install their client M> libraries after I had already created users with the Grant permissions. How did you create users? M> Now that they have reinstalled I can not access mysqladmin in the shell. M> I cannot even do a shutdown. No one not even root can shutdown the MYSQL M> server. I did the test in the manual to see if the server can connect: M> Shell> mysql-u root testIt comes back with the server unable to M> connect. "Unable to connect" is a too short error message. What is the full message? M> In the user table there are three users with all permissions M> (one of them is root) none of the three users are able to do a shutdown M> or any of the permissions that are in the table. It comes back with M> access denied and password = No It means that you didn't used password when you tried to connect. So, if you want to connect to the MySQL server you should use: mysql -u -p or for mysqladmin: mysqladmin -u -p command You can find description of syntax at: http://www.mysql.com/doc/m/y/mysql.html http://www.mysql.com/doc/m/y/mysqladmin.html M> but it is Y in the user table. What M> needs to be done? I can with all three users leave the shell and it will M> accept the passwords and I can go into mysql> and do SQL queries fine. M> Warm M> regards, M> Muriel -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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
Installation question
Hello, My ISP installed MYSQL -max-3.23.49a-pclinux-gnu-i686 on our dedicated server. They discovered they did not install their client libraries after I had already created users with the Grant permissions. Now that they have reinstalled I can not access mysqladmin in the shell. I cannot even do a shutdown. No one not even root can shutdown the MYSQL server. I did the test in the manual to see if the server can connect: Shell> mysql-u root testIt comes back with the server unable to connect. In the user table there are three users with all permissions (one of them is root) none of the three users are able to do a shutdown or any of the permissions that are in the table. It comes back with access denied and password = No but it is Y in the user table. What needs to be done? I can with all three users leave the shell and it will accept the passwords and I can go into mysql> and do SQL queries fine. Thank you for your time. Warm regards, Muriel - 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
Installation question on Linux.
Hi, all, I am installing MySQL+Gemini 3.23.41 on Linux 6.2. I followed the instructions such as "tar xvf", etc. Then I came to the : "CFLAGS="-03" \ CXX=gcc CXXFLAGS="-03 -felide-constructors -fno-exceptions -fno-rtti" \ ./configure --prefix=~/local/mysql\ --enable-assembler --with-mysqld-ldflags=-all-static After these commands come a lot of checking, some are no, some are yes. I am not sure if every checking should be yes. The last 4 checkings are: checking for tgetent in -lncurses... no checking for tgetent in -lcurses... no checking for tgetent in -ltermcap... no checking for termcap functions library... configure: error: No curses/termcap library found Did I miss anything? Wei - 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: Post Installation Question
Hi,
I have done the following
$./bin/mysql -uroot mysql
Reading table information for completion of table and
column names
You can turn off this feature to get a quicker startup
with -A
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 12 to server version:
3.23.42-log
Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.
mysql> UPDATE user SET password=password('test123')
where user='root';
Query OK, 2 rows affected (0.24 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> commit
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Restarted safe_mysqld
but when I attempt to connect using mysql client (from
windows 2000), I get
Host 'my_hostname' is not allowed to connect to this
MySQL server
p.s. I am only starting and stopping mysql from Host
as mysql user.
Regards
--- Intekhab Choudhury <[EMAIL PROTECTED]>
wrote:
> Hi,
>I think I have one of the most basic question. I
> just installed mysql 3.23.4x version for HPUX 10.20
> (binaries). Installation went fine, but now can't
> access mysql (created the database following mysql
> direction, but can't go forwardfollowing error
> is
> what I get... (Try to access using gui from a
> windows
> box, but no access
>
> $/usr/local/mysql
> [136] ./bin/mysqlshow mysql
> ./bin/mysqlshow: Access denied for user:
> '@localhost'
> to database 'mysql'
>
> $./bin/mysql -e "select host,db,user from db" mysql
>
>
> ERROR 1044: Access denied for user: '@localhost' to
> database 'mysql'
>
> Obviously authentication mess up, but I didn't do
> anything (just followed the direction from mysql
> documents)
>
> Anyway, how can I access my installation version?
> Thanks for help
>
> Regards
>
> IHC
>
> __
> Do You Yahoo!?
> Listen to your Yahoo! Mail messages from any phone.
> http://phone.yahoo.com
>
>
-
> 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
>
__
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com
-
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: Newbie Linux 7 installation question
Gerald's recommendation worked peachily -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Friday, April 20, 2001 8:31 AM To: Rolf Hopkins Cc: Steve Tuckner; [EMAIL PROTECTED] Subject: Re: Newbie Linux 7 installation question No, it can't find the file because the mysql database directory is owned by root. Rolf Hopkins wrote: > > More like it has already started. Do "ps -ef | grep mysql" to find out. > > - Original Message - > From: "Gerald Clark" <[EMAIL PROTECTED]> > To: "Steve Tuckner" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Friday, April 20, 2001 0:21 > Subject: Re: Newbie Linux 7 installation question > > > chown -R mysql /var/mysql > > > > > > Steve Tuckner wrote: > > > > > > When I run safe_mysqld, it starts and ends immediatly. In the mysqld.log > in > > > /var/log it has the following: > > > > > > 010418 21:19:47 mysqld started > > > 010418 21:19:47 /usr/libexec/mysqld: Can't find file: > './mysql/host.frm' > > > (errno: 13) > > > 010418 21:19:47 mysqld ended > > > > > > Below is the my.cnf file > > > > > > [mysqld] > > > datadir=/var/lib/mysql > > > socket=/var/lib/mysql/mysql.sock > > > > > > [mysql.server] > > > user=mysql > > > basedir=/var/lib > > > > > > [safe_mysqld] > > > err-log=/var/log/mysqld.log > > > pid-file=/var/run/mysqld/mysqld.pid > > > > > > I ran mysql_install_db and it created database files in > > > /var/lib/mysql/mysql. The file host.frm does exist in that directory. I > > > tried copying those files /var/lib/mysql but it made no difference. I > have > > > no ethernet card in the machine and therefore it would be running as > > > localhost. > > > > > > Any ideas??? > > > > > > Thanks, > > > > > > Steve > > > > > > > > > > - > > 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: Newbie Linux 7 installation question
No, it can't find the file because the mysql database directory is owned by root. Rolf Hopkins wrote: > > More like it has already started. Do "ps -ef | grep mysql" to find out. > > - Original Message - > From: "Gerald Clark" <[EMAIL PROTECTED]> > To: "Steve Tuckner" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Friday, April 20, 2001 0:21 > Subject: Re: Newbie Linux 7 installation question > > > chown -R mysql /var/mysql > > > > > > Steve Tuckner wrote: > > > > > > When I run safe_mysqld, it starts and ends immediatly. In the mysqld.log > in > > > /var/log it has the following: > > > > > > 010418 21:19:47 mysqld started > > > 010418 21:19:47 /usr/libexec/mysqld: Can't find file: > './mysql/host.frm' > > > (errno: 13) > > > 010418 21:19:47 mysqld ended > > > > > > Below is the my.cnf file > > > > > > [mysqld] > > > datadir=/var/lib/mysql > > > socket=/var/lib/mysql/mysql.sock > > > > > > [mysql.server] > > > user=mysql > > > basedir=/var/lib > > > > > > [safe_mysqld] > > > err-log=/var/log/mysqld.log > > > pid-file=/var/run/mysqld/mysqld.pid > > > > > > I ran mysql_install_db and it created database files in > > > /var/lib/mysql/mysql. The file host.frm does exist in that directory. I > > > tried copying those files /var/lib/mysql but it made no difference. I > have > > > no ethernet card in the machine and therefore it would be running as > > > localhost. > > > > > > Any ideas??? > > > > > > Thanks, > > > > > > Steve > > > > > > > > > > - > > 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: Newbie Linux 7 installation question
More like it has already started. Do "ps -ef | grep mysql" to find out. - Original Message - From: "Gerald Clark" <[EMAIL PROTECTED]> To: "Steve Tuckner" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, April 20, 2001 0:21 Subject: Re: Newbie Linux 7 installation question > chown -R mysql /var/mysql > > > Steve Tuckner wrote: > > > > When I run safe_mysqld, it starts and ends immediatly. In the mysqld.log in > > /var/log it has the following: > > > > 010418 21:19:47 mysqld started > > 010418 21:19:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' > > (errno: 13) > > 010418 21:19:47 mysqld ended > > > > Below is the my.cnf file > > > > [mysqld] > > datadir=/var/lib/mysql > > socket=/var/lib/mysql/mysql.sock > > > > [mysql.server] > > user=mysql > > basedir=/var/lib > > > > [safe_mysqld] > > err-log=/var/log/mysqld.log > > pid-file=/var/run/mysqld/mysqld.pid > > > > I ran mysql_install_db and it created database files in > > /var/lib/mysql/mysql. The file host.frm does exist in that directory. I > > tried copying those files /var/lib/mysql but it made no difference. I have > > no ethernet card in the machine and therefore it would be running as > > localhost. > > > > Any ideas??? > > > > Thanks, > > > > Steve > > > > > > - > 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: Newbie Linux 7 installation question
chown -R mysql /var/mysql Steve Tuckner wrote: > > When I run safe_mysqld, it starts and ends immediatly. In the mysqld.log in > /var/log it has the following: > > 010418 21:19:47 mysqld started > 010418 21:19:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' > (errno: 13) > 010418 21:19:47 mysqld ended > > Below is the my.cnf file > > [mysqld] > datadir=/var/lib/mysql > socket=/var/lib/mysql/mysql.sock > > [mysql.server] > user=mysql > basedir=/var/lib > > [safe_mysqld] > err-log=/var/log/mysqld.log > pid-file=/var/run/mysqld/mysqld.pid > > I ran mysql_install_db and it created database files in > /var/lib/mysql/mysql. The file host.frm does exist in that directory. I > tried copying those files /var/lib/mysql but it made no difference. I have > no ethernet card in the machine and therefore it would be running as > localhost. > > Any ideas??? > > Thanks, > > Steve > > - 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
Newbie Linux 7 installation question
When I run safe_mysqld, it starts and ends immediatly. In the mysqld.log in /var/log it has the following: 010418 21:19:47 mysqld started 010418 21:19:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010418 21:19:47 mysqld ended Below is the my.cnf file [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid I ran mysql_install_db and it created database files in /var/lib/mysql/mysql. The file host.frm does exist in that directory. I tried copying those files /var/lib/mysql but it made no difference. I have no ethernet card in the machine and therefore it would be running as localhost. Any ideas??? Thanks, Steve - 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: INSTALLATION QUESTION on Cobalt Raq3
Don't use RPM. The RPMs for the Cobalt RaQ3 suck. I have 8 different Cobalt RaQ3's and here's the way I've used to install: I've installed it this way successfully each time. Sounds like a bit of a pain, but puts you in much better control of MySQL. INSTALLATION INSTRUCTIONS #1 - download the newest MySQL *source* tarball from mysql.com or its mirrors. Do all the following stuff as "root" user: ## UNTAR IT tar -xvfz mysql-#.#.tar.gz ## - FIRST: TO MAKE A USER NAME 'mysql' GROUP NAME 'mysql' TO SAFELY RUN MYSQL UNDER /usr/sbin/groupadd mysql /usr/sbin/useradd mysql -g mysql ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql --with-lz make make install ## - SET THE DATA DIRECTORY TO BE /VAR/DB - MAKE A SYMLINK FOR IT HERE IN THE MYSQL FOLDER cd mysql ln -s /var/db var ## - INSTALL THE BASIC DATABASE NEEDED TO RUN bin/mysql_install_db ## - if there's a problem, do the next step then come back and do this step again. ## - GO SET PERMISSIONS FOR THE DATA DIRECTORY cd /var chown mysql:mysql -R db chmod 700 -R db ## - COPY THE STARTUP/INIT/CONFIG FILES TO THE RIGHT PLACE cd share/mysql cp mysql.server /etc/rc.d/init.d/ cp my-small.cnf /var/db/my.cnf ## - PUT STARTUP FILES IN EVERY STARTUP FOLDER - so if they reboot the server, MySQL starts! cd /etc/rc.d/init.d/ chmod 755 mysql.server cd ../rc3.d ln -s ../init.d/mysql.server S88mysql cd ../rc4.d ln -s ../init.d/mysql.server S88mysql cd ../rc6.d ln -s ../init.d/mysql.server K18mysql cd ../rc0.d ln -s ../init.d/mysql.server K18mysql ## - SYMLINK THE COMMANDS INTO THE PATH SO WE CAN JUST TYPE "mysql" FROM ANYWHERE cd /usr/bin ln -s /usr/local/mysql/bin/* ./ cd /usr/sbin ln -s /usr/local/mysql/bin/* ./ ## - START IT! safe_mysqld & mysqladmin -u root -p password 'somesecretpassword' mysql -u root -p use mysql; delete from user where user=''; exit; from now on, connect to mysql with 'mysql -u root -p' then type the magic password afterwards. Voila! - 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 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSTALLATION QUESTION on Cobalt Raq3
> "l" == lkeeton <[EMAIL PROTECTED]> writes: l> First does anybody know the website address for that searchable l> site that allows you to search on mysql archive emails. I would l> appreciate if I could get that. I also am looking for opinions on Does anyone read the footers on the messages they get from the mailing list or are they just wasting electrons on my box? - 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
Installation Question on MySql and Cobalt Raq3
First does anybody know the website address for that searchable site that allows you to search on mysql archive emails. I would appreciate if I could get that. I also am looking for opinions on the installation of MySql on the Cobalt Raq3. I am really interested in installing the RPM's for that machine. I really don't want to do a manual installation. I want the installation to be smooth and easy without manual configurations. Has anybody had any good experiences with MySql RPM version on the Cobalt Raq3 - 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
INSTALLATION QUESTION on Cobalt Raq3
First does anybody know the website address for that searchable site that allows you to search on mysql archive emails. I would appreciate if I could get that. I also am looking for opinions on the installation of MySql on the Cobalt Raq3. I am really interested in installing the RPM's for that machine. I really don't want to do a manual installation. I want the installation to be smooth and easy without manual configurations. Has anybody had any good experiences with MySql RPM version on the Cobalt Raq3 - 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
