Privet!
>file: './mysql/host.frm' (errno: 13) perror 13 OS error code 13: Permission denied Change the owner of /var/lib/mysql to 'mysql' user. Please next time post your messages to the list, the probability of helpful answers increases in several times :) >On Tue, 31 May 2005 07:03:48 +0200 >Dobroe vremja sutok. Vot eshe dannye s togo komjutera gde mysql ne >hochet zapuskatsea: > >======================================== >[EMAIL PROTECTED] mouse $ cat /etc/hosts ># /etc/hosts: This file describes a number of hostname-to-address ># mappings for the TCP/IP subsystem. It is mostly ># used at boot time, when no name servers are running. ># On small systems, this file can be used instead of a ># "named" name server. Just add the names, addresses ># and any aliases to this file... ># $Header: /home/cvsroot/gentoo-src/rc-scripts/etc/hosts,v 1.8 >2003/08/04 20:12:25 azarah Exp $ ># > >127.0.0.1 localhost >192.168.1.111 mouse mynetwork.mouseware.com >192.168.1.1 router mynetwork.mouseware.com router > ># IPV6 versions of localhost and co >#::1 ip6-localhost ip6-loopback >#fe00::0 ip6-localnet >#ff00::0 ip6-mcastprefix >#ff02::1 ip6-allnodes >#ff02::2 ip6-allrouters >#ff02::3 ip6-allhosts > >======================================== >[EMAIL PROTECTED] mouse $ cat /etc/mysql/my.cnf ># /etc/mysql/my.cnf: The global mysql configuration file. ># $Header: >/var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.0.14-r1,v 1.2 >2004/07/18 02:47:43 dragonheart Exp $ ># ># This file can be simultaneously placed in three places: ># 1. /etc/mysql/my.cnf to set global options. ># 2. /var/lib/mysql/my.cnf to set server-specific options. ># 3. ~/.my.cnf to set user-specific options. ># ># One can use all long options that the program supports. ># Run the program with --help to get a list of them. ># ># The following values assume you have at least 32M RAM! > >[client] >#password = my_password >port = 3306 >socket = /var/run/mysqld/mysqld.sock > >[safe_mysqld] >err-log = /var/log/mysql/mysql.err > >[mysqld] >#skip-innodb >user = mysql >pid-file = /var/run/mysqld/mysqld.pid >socket = /var/run/mysqld/mysqld.sock >log-error = /var/log/mysql/mysqld.err ># If set, mysql logs all queries(general query log). This will be >deprecated in ># 5.0. This logs all queries, even error queries and is slow. ># log = /var/log/mysql/mysql.log ># ># If you really need logging, use rather binary logging. Especially >when doing ># replication. Read ># file:/usr/share/doc/mysql-*/manual.html.gz#Replication ># You can use PURGE MASTER LOGS TO '$hostname-bin.010' to get rid of >old logs ># from $hostname-bin.01 up to $hostname-bin.09 while the slave server >is ># running. ># Before doing that, check which logfile slave curently uses by running ># mysql> SHOW SLAVE STATUS ># To list logfiles on master do: ># mysql> SHOW MASTER LOGS ># Then use PURGE for those not needed anymore only! Never remove the >files ># manually! ># ># Also consult RESET MASTER and RESET SLAVE commands before doing any >changes ># mysql> RESET MASTER - Deletes all binary logs listed in the index ># file, resetting the binlog index file to be >empty. ># mysql> RESET SLAVE - Makes the slave forget its replication position >in ># the master logs. ># mysql> SET SQL_LOG_BIN=0 - this turns off logging (execute on MASTER >only) ># mysql> SET SQL_LOG_BIN=1 - this turns on logging (execute on MASTER >only) ># ># log-bin ># set-variable = binlog-do-db=non_existant ># set-variable = binlog-ignore-db=database_name ># ># server-id has to unique for each master or slave in your network, ># lets use last number from IP address ># server-id = 207 >basedir = /usr >datadir = /var/lib/mysql >tmpdir = /tmp >language = /usr/share/mysql/english >skip-locking >set-variable = key_buffer=16M >set-variable = max_allowed_packet=1M >set-variable = thread_stack=128K ># keep secure by default! >bind-address = 127.0.0.1 ># bind-address = 192.168.1.111 >port = 3306 ># this can make it even more secure: >#skip-networking > >[mysqldump] >quick >set-variable = max_allowed_packet=1M > >[mysql] >#no-auto-rehash # faster start of mysql but no tab completition > >[isamchk] >set-variable = key_buffer=16M > > >======================================== >[EMAIL PROTECTED] mouse $ cat /var/log/mysql/mysqld.err >050531 18:10:17 InnoDB: Started >050531 18:10:17 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' >(errno: 13) >050531 18:10:17 Fatal error: Can't open privilege tables: Can't find >file: './mysql/host.frm' (errno: 13) >050531 18:10:17 Aborting > >050531 18:10:17 InnoDB: Starting shutdown... >050531 18:10:19 InnoDB: Shutdown completed >050531 18:10:19 /usr/sbin/mysqld: Shutdown Complete > >050531 18:12:44 /usr/sbin/mysqld: Shutdown Complete > >050531 18:28:39 /usr/sbin/mysqld: Shutdown Complete > >050531 18:28:45 InnoDB: Started >050531 18:28:45 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' >(errno: 13) >050531 18:28:45 Fatal error: Can't open privilege tables: Can't find >file: './mysql/host.frm' (errno: 13) >050531 18:28:45 Aborting > >050531 18:28:45 InnoDB: Starting shutdown... >050531 18:28:47 InnoDB: Shutdown completed >050531 18:28:47 /usr/sbin/mysqld: Shutdown Complete > >050531 18:56:34 /usr/sbin/mysqld: Shutdown Complete > >050531 18:56:40 InnoDB: Started >050531 18:56:40 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' >(errno: 13) >050531 18:56:40 Fatal error: Can't open privilege tables: Can't find >file: './mysql/host.frm' (errno: 13) >050531 18:56:40 Aborting > >050531 18:56:40 InnoDB: Starting shutdown... >050531 18:56:42 InnoDB: Shutdown completed >050531 18:56:42 /usr/sbin/mysqld: Shutdown Complete > > >======================================== >[EMAIL PROTECTED] mouse # locate host.frm >/var/lib/mysql/mysql/host.frm >/usr/sbin/mysql/host.frm >/home/mouse/mysql/host.frm >/root/mysql/host.frm > >======================================== >[EMAIL PROTECTED] mouse $ ls -al /usr/sbin/mysql/host.frm >-rw-r----- 1 root root 9064 Mar 8 20:14 /usr/sbin/mysql/host.frm >[EMAIL PROTECTED] mouse $ ls -al ~/mysql/host.frm >-rw-r----- 1 mouse users 9064 Mar 8 20:14 /home/mouse/mysql/host.frm > >If you can help me, thanks a lot! > > > > > >"Peter Normann" <[EMAIL PROTECTED]> wrote: > > >>> Mouse Doctor X wrote: >> >>>> > Nice time of the day. >>>> > I apologize I am writing on this address because didn't find >>>> > START >>>> > NEW THREAD on mailing lists page. >>>> > >>>> > The problem is this: I have the freshest version of Gentoo Linux, >>>> > and >>>> > mysql within it. Just didn't modify /etc/mysql/my.cnf, commenting >>>> > only one line: skip-innodb. >>>> > >>>> > Have read about first mysql startup, and launched >>>> > mysql_install_db as >>>> > root. All went ok. Then, /etc/init.d/mysql start, started ok. >>>> > When giving first command: /usr/bin/mysqladmin -u root -h >>>> > my_host >>>> > password 'new-password', it sends me somewhere saying: >>>> > /usr/bin/mysqladmin: connect to server at 'my_host' failed >>>> > error: 'Lost connection to MySQL server during query' >>>> > >>>> > When inspecting /var/log/mysql/mysqld.err log file, find there >>>> > that >>>> > /var/mysql.frm is not found. ... out of comment. Also, when >>>> > stopping >>>> > mysql, it refuses to be stopped. >>>> > >>>> > Help! Thanks in advance >> >>> >>> Have you verified that the data files and directories are owned by >>> the mysql >>> user? >>> >>> /var/mysql.frm looks a little strange to me, but I don't know Gento, >>> but >>> /var should not be the data directory for mysql, but rather >>> /var/mysql or >>> something. Locate the data directories and verify that they are >>> owned by the >>> mysql user. >>> >>> Peter Normann -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
