LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 11-24-2008, 03:18 PM   #1
hophop
LQ Newbie
 
Registered: Mar 2006
Location: Netherland
Posts: 7

Rep: Reputation: 0
Opensuse 10.3 : LAMP install, but problem with starting / config mysql


Hi All,

I've got an problem with starting mysql.
When i do "rcmysql start" (as root) i get the following output :


rcmysql start
Updating MySQL privilege database...
Looking for 'mysql' in: /usr/bin/mysql
Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck
Running 'mysqlcheck'...
mysql.columns_priv OK
mysql.db OK
mysql.func OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.proc OK
mysql.procs_priv OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Running 'mysql_fix_privilege_tables'...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/.protected/mysql.sock' (13)
FATAL ERROR: Upgrade failed


The dir. /var/lib/mysql/.protected/ exists but there is no mysql.sock when i look in this folder.
(i see an hidden file in /var/lib/mysql/ named .run-mysql_upgrade maybe that has something to do with it ?)

Now im realy stuck and cant get it to work. Mysql log tells me the following :

081124 21:13:53 mysqld started
081124 21:13:53 InnoDB: Started; log sequence number 0 43655
081124 21:13:53 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.67' socket: '/var/lib/mysql/.protected/mysql.sock' port: 0 SUSE MySQL RPM
081124 21:13:53 [Note] /usr/sbin/mysqld: Normal shutdown

081124 21:13:53 InnoDB: Starting shutdown...
081124 21:13:54 InnoDB: Shutdown completed; log sequence number 0 43655
081124 21:13:54 [Note] /usr/sbin/mysqld: Shutdown complete

081124 21:13:54 mysqld ended


When i rename the .run-mysql_upgrade file to > #.run-mysql_upgrade I can start the msql by going to YAST > System > System Services (Runlevel)and enable Mysql ( tells me succes with 0 errors.)

But when i type in the following : mysql -u root
i get the error : ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
Dont have a clue what this could be.

I looked up my_cfg :

# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking

# Disable Federated by default
skip-federated

# Replication Master Server (default)
# binary logging is required for replication
# log-bin=mysql-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
# the syntax is:
#
# CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
# MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
# where you replace <host>, <user>, <password> by quoted strings and
# <port> by the master's port number (3306 by default).
#
# Example:
#
# CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
# MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
# start replication for the first time (even unsuccessfully, for example
# if you mistyped the password in master-password and the slave fails to
# connect), the slave will create a master.info file, and any later
# change in this file to the variables' values below will be ignored and
# overridden by the content of the master.info file, unless you shutdown
# the slave server, delete master.info and restart the slaver server.
# For that reason, you may want to leave the lines below untouched
# (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id = 2
#
# The replication master for this slave - required
#master-host = <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user = <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password = <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port = <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin

# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

# The safe_mysqld script
[safe_mysqld]
log-error=/var/lib/mysql/mysqld.log

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log = /var/log/mysqld_multi.log
# user = multi_admin
# password = secret

# If you want to use mysqld_multi uncomment 1 or more mysqld sections
# below or add your own ones.

# WARNING
# --------
# If you uncomment mysqld1 than make absolutely sure, that database mysql,
# configured above, is not started. This may result in corrupted data!
# [mysqld1]
# port = 3306
# datadir = /var/lib/mysql
# pid-file = /var/lib/mysql/mysqld.pid
# socket = /var/lib/mysql/mysql.sock
# user = mysql

# [mysqld2]
# port = 3307
# datadir = /var/lib/mysql-databases/mysqld2
# pid-file = /var/lib/mysql-databases/mysqld2/mysql.pid
# socket = /var/lib/mysql-databases/mysqld2/mysql.sock
# user = mysql

# [mysqld3]
# port = 3308
# datadir = /var/lib/mysql-databases/mysqld3
# pid-file = /var/lib/mysql-databases/mysqld3/mysql.pid
# socket = /var/lib/mysql-databases/mysqld3/mysql.sock
# user = mysql

# [mysqld6]
# port = 3309
# datadir = /var/lib/mysql-databases/mysqld6
# pid-file = /var/lib/mysql-databases/mysqld6/mysql.pid
# socket = /var/lib/mysql-databases/mysqld6/mysql.sock
# user = mysql



I see in other posts here it could be that root is the owner, but it's not.

totaal 20556
-rw-rw---- 1 mysql mysql 10485760 nov 24 21:28 ibdata1
-rw-rw---- 1 mysql mysql 5242880 nov 24 21:29 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 nov 24 18:53 ib_logfile1
drwx------ 2 mysql mysql 4096 nov 24 18:53 mysql
-rw-rw---- 1 mysql mysql 12484 nov 24 21:29 mysqld.log
-rw-rw---- 1 mysql mysql 6 nov 24 21:29 mysqld.pid
srwxrwxrwx 1 mysql mysql 0 nov 24 21:29 mysql.sock
drwx------ 2 mysql mysql 4096 nov 24 21:28 .protected
-rw-r--r-- 1 mysql mysql 0 nov 24 18:52 #.run-mysql_upgrade
-rw-r--r-- 1 mysql mysql 0 nov 24 20:51 ##.run-mysql_upgrade
drwx------ 2 mysql mysql 4096 nov 24 18:53 test
drwxr-xr-x 2 mysql mysql 4096 nov 24 21:29 .tmp


Now i cant get any further with the lamp installation and get phpmyadmin installed
I'm Sorry for my crappy english. I'll hope some1 is willing to help me solve this issue.

Thanks,

Sander

Last edited by hophop; 11-24-2008 at 03:53 PM.
 
Old 11-26-2008, 12:13 AM   #2
you933
LQ Newbie
 
Registered: Nov 2008
Posts: 4

Rep: Reputation: 1
don't you try with
# service mysql
or
# service mysql start

but I use opensuse 11.
 
1 members found this post helpful.
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem Starting MySQL on Fresh Fedora 8 Install w/ Yum'd MySQL blong4life Linux - Server 2 07-04-2008 08:44 PM
problem starting mysql, new install Robin01 Linux - Newbie 6 08-29-2005 07:12 PM
Installing LAMP with MySQL 4.1 - close but stuck with Apache problem David Mann Linux - Software 2 11-10-2004 09:19 PM
LAMP(Linux, Apache, MySQL, PHP) Problem gamehack Slackware 7 08-17-2004 03:52 PM
Starting MySQL on fresh Slack install subnet_rx Slackware 7 06-26-2004 05:44 PM


All times are GMT -5. The time now is 11:11 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration