Početak › Forumi › Linuks distribucije › Mandriva › Softver › mysql error 13
- This topic has 11 odgovora, 3 glasa, and was last updated 21 years, 2 months ranije by
popeye.
-
AutorČlanci
-
28. januar 2005. u 11:59 pm #4750
samadhi
Učesnik050129 0:51:25 Warning: Can’t create test file /var/lib/mysql/localhost.lower-test
/usr/libexec/mysqld: Can’t change dir to ‘/var/lib/mysql/’ (Errcode: 13)
050129 0:51:25 Aborting050129 0:51:25 /usr/libexec/mysqld: Shutdown Complete
samadhi@localhost:~$
za startovanje mysqld-a
a za rc.mysqld isto takodje
root@localhost:/home/samadhi# /etc/rc.d/rc.mysqld start
root@localhost:/home/samadhi# Starting mysqld daemon with databases from /var/lib/mysql
050129 00:55:52 mysqld endedroot@localhost:/home/samadhi#
ima neko resenje distro je Slackware 10
29. januar 2005. u 11:36 am #24331popeye
Glavni majstorDa li si pokrenuo mysql_install_db?
29. januar 2005. u 1:14 pm #24332samadhi
Učesniksamadhi:~# /usr/bin/mysql_install_db
Installing all prepared tables
050129 14:09:08 /usr/libexec/mysqld: Shutdown Complete
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password ‘new-password’
/usr/bin/mysqladmin -u root -h localhost password ‘new-password’
See the manual for more instructions.NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-testsPlease report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.comevo sta dobijem i jos uvek nece
30. januar 2005. u 12:04 am #24333popeye
Glavni majstorKada pokrećeš sa etc/rc.d/rc.mysqld skriptom, da li je poruka o grešci ista kao i ranije?
Pošalji izlaz naredbi ls -l /var/lib i ls -l /var/lib/mysql.
1. februar 2005. u 10:15 pm #24334samadhi
Učesnik050129 13:35:52 mysqld started
050129 13:35:54 InnoDB: Started
050129 13:35:55 Fatal error: Can’t open privilege tables: Table ‘mysql.host’ doesn’t exist
050129 13:35:55 Aborting050129 13:35:55 InnoDB: Starting shutdown…
050129 13:35:57 InnoDB: Shutdown completed
050129 13:35:57 /usr/libexec/mysqld: Shutdown Complete050129 13:35:57 mysqld ended
050129 14:07:18 mysqld started
050129 14:07:19 InnoDB: Started
050129 14:07:19 Fatal error: Can’t open privilege tables: Can’t find file: ‘./mysql/host.frm’ (errno: 13)
050129 14:07:19 Aborting050129 14:07:19 InnoDB: Starting shutdown…
050129 14:07:21 InnoDB: Shutdown completed
050129 14:07:21 /usr/libexec/mysqld: Shutdown Complete050129 14:07:21 mysqld ended
evo jos info od localhost.err u direktorijumu za mysql
2. februar 2005. u 4:45 pm #24335popeye
Glavni majstorPošalji izlaz naredbi ls -l /var/lib i ls -l /var/lib/mysql.
2. februar 2005. u 5:14 pm #24336samadhi
Učesniksamadhi@localhost:~$ ls -l /var/lib
total 68
drwxr-xr-x 2 root root 4096 Jun 18 2004 arpd/
drwxr-xr-x 4 root root 4096 Mar 14 2003 bsdgames/
drwxr-xr-x 3 root root 4096 Jun 18 2004 cache/
drwxr-xr-x 2 root root 4096 Jun 8 2004 elm/
drwxrwxr-x 2 root games 4096 Dec 17 22:59 games/
drwxrwx–T 2 root gdm 4096 Feb 2 15:49 gdm/
drwxr-xr-x 2 root root 4096 Dec 17 22:58 log/
drwxr-xr-x 2 root root 4096 Apr 7 2002 logrotate/
drwxr-x— 4 mysql mysql 4096 Feb 2 15:49 mysql/
drwxr-xr-x 2 root root 4096 Feb 2 12:11 nfs/
drwxr-xr-x 2 root root 4096 Feb 2 15:48 pcmcia/
drwxr-xr-x 2 root root 4096 Jan 2 14:50 rpm/
drwxr-xr-x 36 root root 4096 Dec 17 23:03 scrollkeeper/
drwxr-xr-x 2 root root 4096 Jan 5 01:07 slmodem/
drwxr-x— 2 root slocate 4096 Jan 24 20:34 slocate/
drwxr-xr-x 2 root root 4096 Jun 5 2004 xdm/
drwxr-xr-x 2 root root 4096 Feb 2 15:50 xkb/
samadhi@localhost:~$root@localhost:/home/samadhi# ls -l /var/lib/mysql
total 20584
-rw-rw—- 1 mysql mysql 25088 Dec 17 23:09 ib_arch_log_0000000000
-rw-rw—- 1 mysql mysql 5242880 Feb 2 15:49 ib_logfile0
-rw-rw—- 1 mysql mysql 5242880 Dec 17 23:09 ib_logfile1
-rw-rw—- 1 mysql mysql 10485760 Feb 2 15:49 ibdata1
-rw-rw—- 1 mysql root 28413 Feb 2 15:49 localhost.err
drwx—— 2 root root 4096 Jan 29 14:06 mysql
drwx—— 2 root root 4096 Jan 29 14:06 test
root@localhost:/home/samadhi#3. februar 2005. u 12:24 am #24337popeye
Glavni majstor# chown -R mysql:mysql /var/lib/mysql
4. februar 2005. u 6:37 pm #24338samadhi
Učesnikradi!!
koji je razlog zbog koga nije htelo bilo je na root ?
4. februar 2005. u 10:37 pm #24339popeye
Glavni majstorDa, baza nije mogla da pristupi sistemskim tabelama.
-
AutorČlanci
Forum ‘Softver’ je zaključan za nove teme i odgovore.