How to turn off read only for MySQL tables so UPDATE will work
I am trying to learn PHP using the tutorial for DWMX on macromedia.com. I was doing pretty good until it came time to edit a record. When I tried the page, it said the 'album' table was read only. I had copied the database files from my computer to the server so I went back and checked all the permissions. I made them identical to the tables in a database that was working (owner = mysql with 660 permissions). Then I double checked the privileges in the mysql db table itself for the connection user. I had Y's for select, insert, update, and delete for the database in question so that checked. I have googled for guidance and RTFM but can't find anything that tells me how to turn off the read only for the tables. This is probably something very simple to solve but my brain is starting to fail me. Is this something I should ask the Linux list for help on? Carol Andrejak Webmaster Delaware State University Grossley Hall Rm. 1 302-857-7045
Turn off read only in tables
I am trying to learn PHP using the tutorial for DWMX on macromedia.com. I was doing pretty good until it came time to edit a record. When I tried the page, it said the 'album' table was read only. I had copied the database files from my computer to the server so I went back and checked all the permissions. I made them identical to the tables in a database that was working (owner = mysql with 660 permissions). Then I double checked the privileges in the mysql db table itself for the connection user. I had Y's for select, insert, update, and delete for the database in question so that checked. I have googled for guidance and RTFM but can't find anything that tells me how to turn off the read only for the tables. This is probably something very simple to solve but my brain is starting to fail me. *help* Carol Andrejak Webmaster Delaware State University Grossley Hall Rm. 1 302-857-7045
Lost Password
Hello Listers, I have a problem in that I cannot find my user id and password to log into mysql as administrator. I can never remember passwords so I write them all down in a small book however when I reinstalled mysql early last month, evidently I neglected to write down the new user id and password in my book. I haven't touched telnet since then. So now I can't log in to create a new user or do anything else. Is it possible to sit down in front of the server logged in as root and find the file that has this information and have a look at it? Maybe if I can see the user names it'll jog my memory as to the password. I can try a couple to see if any work. If this is not possible, what recourse do I have? I don't want to mess with the database and start over and I seriously don't want to have to do anything to mysql as it took me two weeks to get it to work with the DBI perl module. Now that it's working, I'm terrified to touch it in case it breaks. Thanks for any guidance. I promise this time to not forget to write it down. Carol Andrejak Webmaster Delaware State University Grossley Hall Rm. 1 302-857-7045
Cannot start MySQL (errno 13)
Hi all, I have been working on getting MySQL going all day. Initially I had it working but had problems with mysqladmin. Figured that one out shutdown the server and tried to restart but I now have an error. This is what I found in my errorlog. In looking at the documentation I think I have to do something with UMASK? I read what it said but I'm still not sure exactly what I'm supposed to do. 031010 09:11:54 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 031010 9:11:54 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 031010 9:11:56 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 031010 9:11:57 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 031010 9:12:03 InnoDB: Started /usr/sbin/mysqld: ready for connections. Version: '4.0.15-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 031010 15:38:47 /usr/sbin/mysqld: Normal shutdown 031010 15:38:48 InnoDB: Starting shutdown... 031010 15:38:49 InnoDB: Shutdown completed 031010 15:38:49 /usr/sbin/mysqld: Shutdown Complete 031010 15:38:49 mysqld ended 031010 15:40:36 mysqld started 031010 15:40:36 InnoDB: Started 031010 15:40:36 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031010 15:40:36 Aborting 031010 15:40:36 InnoDB: Starting shutdown... 031010 15:40:39 InnoDB: Shutdown completed 031010 15:40:39 /usr/sbin/mysqld: Shutdown Complete 031010 15:40:39 mysqld ended = Carol Andrejak Webmaster Delaware State University Grossley Hall Rm. 1 302-857-7045 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fwd: Re: Error trying to start mysqladmin
--- Carol Andrejak <[EMAIL PROTECTED]> wrote: > Date: Fri, 10 Oct 2003 10:40:53 -0700 (PDT) > From: Carol Andrejak <[EMAIL PROTECTED]> > Subject: Re: Error trying to start mysqladmin > To: Carol Andrejak <[EMAIL PROTECTED]> > > While I've been waiting, these are the other things > I > have tried: > I deleted all the grant tables and re-ran > mysql_install_db. Then I tried the mysqladmin -u > root > password 'password' command again but still got the > same error. So I went into the mysql database and > took > a look at the user table and this is what it has for > Host | User | Password > localhost | root | (password) > www.desu.edu | root | (password) > localhost | (empty) | (empty) > www.desu.edu | (empty) | (empty) > > I keep reading the manual looking for more ideas but > I've tried just about everything. Anybody have any > ideas? > > > --- Carol Andrejak <[EMAIL PROTECTED]> wrote: > > I have just installed latest version of MySQL on > > RedHat 8 and am trying to get mysqladmin to run. I > > have run the mysql_install_db and set the root and > > host passwords. I am able to log in to regular > mysql > > ok and issue commands. But whenever I try to use > > mysqladmin to check version status etc. I get this > > error: > > mysqladmin version > > mysqladmin: connect to server at 'localhost' > failed > > error: 'Access denied for user: '[EMAIL PROTECTED]' > > (Using password: NO)' > > > > I have tried everything I can think of including > > 'mysqladmin -u root', 'mysqladmin -u root -p' and > > various other flavors and still the same error. I > > have > > tried setting the password from within mysql and > > checked the mysql database for users and > everything > > is > > there. I have checked documentation and can't find > > anything that addresses this. What am I missing? > > > > = > > > > Carol Andrejak > > Webmaster > > Delaware State University > > Grossley Hall Rm. 1 > > 302-857-7045 > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > = > > Carol Andrejak > Webmaster > Delaware State University > Grossley Hall Rm. 1 > 302-857-7045 > > > = Carol Andrejak Webmaster Delaware State University Grossley Hall Rm. 1 302-857-7045 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error trying to start mysqladmin
I have just installed latest version of MySQL on RedHat 8 and am trying to get mysqladmin to run. I have run the mysql_install_db and set the root and host passwords. I am able to log in to regular mysql ok and issue commands. But whenever I try to use mysqladmin to check version status etc. I get this error: mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' I have tried everything I can think of including 'mysqladmin -u root', 'mysqladmin -u root -p' and various other flavors and still the same error. I have tried setting the password from within mysql and checked the mysql database for users and everything is there. I have checked documentation and can't find anything that addresses this. What am I missing? = Carol Andrejak Webmaster Delaware State University Grossley Hall Rm. 1 302-857-7045 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to uninstall MySQL
This may seem like a strange problem but I have unwittingly managed to install two instances of MySQL on RedHat 8. One is the compiled binary version (which is what starts when the system is booted) and the other was from an RPM. I 'thought' I have removed the binary flavor before installing the rpm flavor but I was wrong. I need to get rid of both instances of MySQL so I can start over. I am having a devil of a time trying to get a DBD-Msql-Mysql module installed and since I have created such a mess (to the point where I had to rename the mysql.d file in order to get Apache to run again, my solution is to take everything off, reinstall the RPMs for MySQL server, client, shared, and devel, and THEN try to get the DBD-Mysql module installed. (And hopefully this time it will be able to find the files it wants in the places it wants them). And just so you know, I've already tried CPAN and also a force install but with negative results each time (in that it absolutely refused to install). All this because I'm trying to load WebEvent calendar software and it needs the DBI-DBD modules. Finally, I'm very new to Linux and have to drag all my books and documentation with me every time I go back to work on the server so please do not assume that I know what I'm doing. I'm a web designer who has been tasked to learn how to deal with the server sink or swim style. I will be very grateful for any guidance. Carol Andrejak DSU Webmaster Grossley Hall Rm. 7 302-857-7045