Get Paid to Participate - up to $1 per post!     Twitter     Facebook     Google+
Hosting Discussion
 

forgot password?



Closed Thread


Old
  Post #1 (permalink)   01-26-2017, 10:04 PM
Account Disabled
 
Join Date: Aug 2010
Posts: 377

Status: vegas is offline
Mysql restarts
mysqld dont restart
It seems I need to grant permissions to mysql user so mysqld restart
duno how on mysql 5.0 centos 5.11 via ssh
I have got all my databases on var dir and php files load well ,certain scripts appear just with coding maybe mysql aint well sincronized to php 5.2.17

I guess I have some dependencies of old MR kloxo like mysql 5.1 since I uninstalled in order to install mysql 5.0 but it dont seem to pump it up well ,mysql devel cant be installed and mysql server please bring some knowledge
 
 


Old
  Post #2 (permalink)   01-28-2017, 07:42 PM
HD Newbie
 
Join Date: Aug 2015
Location: San Diego, US
Posts: 6
Send a message via Skype™ to Boxne

Status: Boxne is offline
Try to change ownership of those directories to the MySQL user.

Chown is the command you would want to use.

Chown <User> <Directory>

Ex. Chown root /var

Thank you.
__________________
Boxne Network Solutions
(855) 426-4440
https://boxne.com
 
 


Old
  Post #3 (permalink)   01-31-2017, 06:00 AM
HD Newbie
 
Join Date: Jan 2017
Posts: 7

Status: engrossweb is offline
Generally permission should be assigned to mysql user on mysql data folder and others. But before that I suggest you to check the mysql error logs just to find out the exactly clue.
 
 


Old
  Post #4 (permalink)   01-31-2017, 07:46 PM
Account Disabled
 
Join Date: Aug 2010
Posts: 377

Status: vegas is offline
Thank you very much Broxne then granting the permissions to the mySQL user would be prettym much like this
Chown mySQL /var
?
engrossweb can you please speak about directories paths?

I appreciate you reading a lot
 
 


Old
  Post #5 (permalink)   02-20-2017, 11:17 PM
HD Newbie
 
Join Date: Mar 2016
Posts: 36

Status: praveenk is offline
Quote:
Originally Posted by vegas View Post
Mysql restarts
mysqld dont restart
It seems I need to grant permissions to mysql user so mysqld restart
duno how on mysql 5.0 centos 5.11 via ssh
I have got all my databases on var dir and php files load well ,certain scripts appear just with coding maybe mysql aint well sincronized to php 5.2.17

I guess I have some dependencies of old MR kloxo like mysql 5.1 since I uninstalled in order to install mysql 5.0 but it dont seem to pump it up well ,mysql devel cant be installed and mysql server please bring some knowledge
If you don't mind, simply copy and paste the mysql error logs, so we can provide you correct command to resolve the issue because one wrong chown command can cause you many problems.
__________________
ktchost.com - Reliable Web Hosting Provider
E-commerce Ready Hosting | Pure SSD Cloud/VPS | Offshore Dedicated Server
24/7 Reliable Tech Support | Monitoring Service | R1Soft Backup
 
 


Old
  Post #6 (permalink)   03-02-2017, 12:02 AM
HD Addict
 
Join Date: Sep 2014
Location: India
Posts: 196
Send a message via Skype™ to 24x7server

Status: 24x7server is offline
Hi,

First of all check the MySQL directory where the data is loaded and check if they have mysql user ownership assigned to them.

# mysqladmin var | grep -i datadir

suppose you have mysql at location /var/lib/mysql, then below is the command to change the ownership
# chown mysql:mysql /var/lib/mysql
__________________
www.24x7servermanagement.com
Server Management, Server Security, Server Monitoring.
Network Monitoring Team !! Skype: techs24x7
 
 


Old
  Post #7 (permalink)   03-03-2017, 06:53 PM
Account Disabled
 
Join Date: Aug 2010
Posts: 377

Status: vegas is offline
Yes 24x7server because the reason why mysqld dont restart is because the actual mySQL dont have a user named mySQL as being the owner,isnt it?
 
 
Closed Thread

Thread Tools

New Post New Post   Old Post Old Post
Posting Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Sponsored By: