Difference between revisions of "OS-Linux-Service-Mysql"

From KRayWiki
Jump to navigation Jump to search
(Copy from PmWiki)
 
(Convert markup from PmWiki to MediaWiki)
Line 1: Line 1:
−
!! General Information
+
; See Also : [[OS-Linux]]<br />
  
−
!!! Server Details
+
= General Information =
  
−
:Port : 3306
+
<blockquote>
  
−
!!! Client Details
+
== Server Details ==
  
−
:name: mysql
+
; Port : 3306
  
−
!! Troubleshooting Hints
+
== Client Details ==
  
−
# Upon trying to secure the root user with `mysqladmin -u root -h $(hostname) password 'new-password'\\
+
; name : mysql
−
(as advised when first starting the server):
 
−
** mysqladmin: connect to server at 'duo_10s.kbulgrien.att.net' failed\\
 
−
error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111'
 
−
*** Is bind-address set in /etc/my.cnf?
 
−
*** Is bind-address in /etc/my.cnf the same as <code>-h $(hostname)</code>?
 
−
# Upon attempting a start of the client with `mysql`:\\
 
  
−
** ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
+
</blockquote>
−
*** Start the client with `mysql -p`and enter the appropriate password when prompted.
 
−
** ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
 
−
*** Start the server with `service mysqld start`.
 
  
−
!! Files & Folders
+
= Troubleshooting Hints =
  
−
(:table bgcolor="#C0C0C0" cellpadding="0" cellspacing="1" :)
+
<blockquote>
−
(:head bgcolor="#808080":) Root
+
 
−
(:head bgcolor="#808080":) Directory&nbsp;Tree&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
+
# Upon trying to secure the root user with `mysqladmin -u root -h $(hostname) password 'new-password'<br />(as advised when first starting the server):
−
(:head bgcolor="#808080":) Description
+
#* mysqladmin: connect to server at 'duo_10s.kbulgrien.att.net' failed
−
(:cellnr rowspan="3" :) /etc/
+
#: error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111'
−
(:cell:)
+
#:* Is bind-address set in /etc/my.cnf?
−
(:cell:) Configuration file area
+
#:* Is bind-address in /etc/my.cnf the same as <code>-h $(hostname)</code>?
−
(:cellnr bgcolor="#CFCFCF":) my.cnf
+
# Upon attempting a start of the client with `mysql`:
−
(:cell bgcolor="#CFCFCF":)
+
#:
−
(:cellnr:) mysqlmanager.passwd
+
#* ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
−
(:cell:) &nbsp;
+
#** Start the client with `mysql -p`and enter the appropriate password when prompted.
−
(:cellnr bgcolor="#CFCFCF" rowspan="2" :) /etc/rc.d/init.d/
+
#* ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
−
(:cell bgcolor="#CFCFCF":) &nbsp;
+
#** Start the server with `service mysqld start`.
−
(:cell bgcolor="#CFCFCF":) &nbsp;
+
 
−
(:cellnr:) mysqld
+
</blockquote>
−
(:cell:) &nbsp;
+
 
−
(:cellnr bgcolor="#CFCFCF" rowspan="2" :) /etc/sysconfig/
+
= Files & Folders =
−
(:cell bgcolor="#CFCFCF":) &nbsp;
+
 
−
(:cell bgcolor="#CFCFCF":) &nbsp;
+
<blockquote>
−
(:cellnr:) mysqld
+
 
−
(:cell:) &nbsp;
+
{| bgcolor="#C0C0C0" cellpadding="0" cellspacing="1"
−
(:cellnr bgcolor="#CFCFCF" rowspan="2" :) /usr/lib*/mysql/mysql/plugin/
+
! bgcolor="#808080" | Root
−
(:cell bgcolor="#CFCFCF":) &nbsp;
+
! bgcolor="#808080" | Directory&nbsp;Tree&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
−
(:cell bgcolor="#CFCFCF":) &nbsp;
+
! bgcolor="#808080" | Description
−
(:cellnr:) *.so
+
|-
−
(:cell:) &nbsp;
+
| rowspan="3" style="vertical-align: top;" | /etc/
−
(:cellnr bgcolor="#CFCFCF" rowspan="2" :) /usr/sbin/
+
|
−
(:cell bgcolor="#CFCFCF":) &nbsp;
+
| Configuration file area
−
(:cell bgcolor="#CFCFCF":) &nbsp;
+
|-
−
(:cellnr:) mysqld
+
| bgcolor="#CFCFCF" | my.cnf
−
(:cell:) &nbsp;
+
| bgcolor="#CFCFCF" |
−
(:cellnr bgcolor="#CFCFCF" rowspan="3" :) /var/lib/mysql/
+
|-
−
(:cell bgcolor="#CFCFCF":) &nbsp;
+
| mysqlmanager.passwd
−
(:cell bgcolor="#CFCFCF":) &nbsp;
+
| &nbsp;
−
(:cellnr:) mysql.sock
+
|-
−
(:cell:) &nbsp;
+
| bgcolor="#CFCFCF" rowspan="2" style="vertical-align: top;" | /etc/rc.d/init.d/
−
(:cellnr bgcolor="#CFCFCF":) mysqlmanager.sock
+
| bgcolor="#CFCFCF" | &nbsp;
−
(:cell bgcolor="#CFCFCF":) &nbsp;
+
| bgcolor="#CFCFCF" | &nbsp;
−
(:cellnr rowspan="2" :) /var/log/mysql/
+
|-
−
(:cell:) &nbsp;
+
| mysqld
−
(:cell:) &nbsp;
+
| &nbsp;
−
(:cellnr bgcolor="#CFCFCF":) mysqld.log
+
|-
−
(:cell bgcolor="#CFCFCF":) &nbsp;
+
| bgcolor="#CFCFCF" rowspan="2" style="vertical-align: top;" | /etc/sysconfig/
−
(:cellnr rowspan="3" :) /var/run/mysqld
+
| bgcolor="#CFCFCF" | &nbsp;
−
(:cell:) &nbsp;
+
| bgcolor="#CFCFCF" | &nbsp;
−
(:cell:) &nbsp;
+
|- mysqld
−
(:cellnr bgcolor="#CFCFCF":) mysqld.pid
+
| &nbsp;
−
(:cell bgcolor="#CFCFCF":) &nbsp;
+
|-
−
(:cellnr:) mysqlmanager.pid
+
| bgcolor="#CFCFCF" rowspan="2" style="vertical-align: top;" | /usr/lib*/mysql/mysql/plugin/
−
(:cell:) &nbsp;
+
| bgcolor="#CFCFCF" | &nbsp;
−
(:tableend:)
+
| bgcolor="#CFCFCF" | &nbsp;
 +
|-
 +
| *.so
 +
| &nbsp;
 +
|-
 +
| bgcolor="#CFCFCF" rowspan="2" style="vertical-align: top;" | /usr/sbin/
 +
| bgcolor="#CFCFCF" | &nbsp;
 +
| bgcolor="#CFCFCF" | &nbsp;
 +
|-
 +
| mysqld
 +
| &nbsp;
 +
|-
 +
| bgcolor="#CFCFCF" rowspan="3" style="vertical-align: top;" | /var/lib/mysql/
 +
| bgcolor="#CFCFCF" | &nbsp;
 +
| bgcolor="#CFCFCF" | &nbsp;
 +
|-
 +
| mysql.sock
 +
| &nbsp;
 +
|-
 +
| bgcolor="#CFCFCF" | mysqlmanager.sock
 +
| bgcolor="#CFCFCF" | &nbsp;
 +
|-
 +
| rowspan="2" style="vertical-align: top;" | /var/log/mysql/
 +
| &nbsp;
 +
| &nbsp;
 +
|-
 +
| bgcolor="#CFCFCF" | mysqld.log
 +
| bgcolor="#CFCFCF" | &nbsp;
 +
|-
 +
| rowspan="3" style="vertical-align: top;" | /var/run/mysqld
 +
| &nbsp;
 +
| &nbsp;
 +
|-
 +
| bgcolor="#CFCFCF" | mysqld.pid
 +
| bgcolor="#CFCFCF" | &nbsp;
 +
|-
 +
| mysqlmanager.pid
 +
| &nbsp;
 +
|}
 +
 
 +
</blockquote>
 +
 
 +
[[Category:OS]]
 +
[[Category:OS-Linux]]
 +
[[Category:OS-Linux-Service]]

Revision as of 04:03, 6 February 2018

See Also 
OS-Linux

General Information

Server Details

Port 
3306

Client Details

name 
mysql

Troubleshooting Hints

  1. Upon trying to secure the root user with `mysqladmin -u root -h $(hostname) password 'new-password'
    (as advised when first starting the server):
    • mysqladmin: connect to server at 'duo_10s.kbulgrien.att.net' failed
    error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111'
    • Is bind-address set in /etc/my.cnf?
    • Is bind-address in /etc/my.cnf the same as -h $(hostname)?
  2. Upon attempting a start of the client with `mysql`:
    • ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
      • Start the client with `mysql -p`and enter the appropriate password when prompted.
    • ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
      • Start the server with `service mysqld start`.

Files & Folders

Root Directory Tree          Description
/etc/ Configuration file area
my.cnf
mysqlmanager.passwd  
/etc/rc.d/init.d/    
mysqld  
/etc/sysconfig/    
 
/usr/lib*/mysql/mysql/plugin/    
*.so  
/usr/sbin/    
mysqld  
/var/lib/mysql/    
mysql.sock  
mysqlmanager.sock  
/var/log/mysql/    
mysqld.log  
/var/run/mysqld    
mysqld.pid  
mysqlmanager.pid  
Retrieved from "https://wiki.bulgriens.net/index.php?title=OS-Linux-Service-Mysql&oldid=220"