Mysql [Warning] Can't create test file

526590 次阅读 by 九九 2012-07-23 | 标签:服务器 问题

啊!!这Linux就是权限流,各种权限引发的时间消耗战,搞来搞去,找来找去,最后还是在“权限”这两个字上面找到了解法~为了让数据库文件能更加的安全,我把Mysql Database的目录指向到了Home下的一个库目录,并把此目录的所有东西都给了mysql用户,执行:

#sudo chmod mysql:mysql -R xxxx

可弄了半天,还是报着

Mysql [Warning] Can't create test file

之类的错误。我找不到解法了,一路狂Google,找到了篇Blog,如下所写:

在一篇老外的帖子中找到了大概原因,大概原因是安装了SELINUX策略后,无论APACHE或MYSQL都要更改目录的权限

如果是APACHE,方法为:

# chcon -R -h -t httpd_sys_content_t /www/web/

如果是mysql,方法为:

# chcon -R -t mysqld_db_t /mysql

啊!!重新的来

#sudo service mysqld start
mysqld start [成功]

评论(27831)

salon massage lyon To 九九 (3小时以前)

Hi there everyone, it's my first visit at this web site, and piece of writing is really fruitful in support of me, keep up posting such posts. https://goo.gl/maps/RLPFGxUQTms

massage lyon croix rousse To 九九 (7小时以前)

My brother suggested I might like this blog. He was totally right. This post truly made my day. You cann't imagine just how much time I had spent for this info! Thanks! https://goo.gl/maps/RLPFGxUQTms

massage lyon france To 九九 (17小时以前)

Good day I am so thrilled I found your blog page, I really found you by accident, while I was browsing on Aol for something else, Anyways I am here now and would just like to say thank you for a remarkable post and a all round enjoyable blog (I also love the theme/design), I don't have time to browse it all at the minute but I have saved it and also included your RSS feeds, so when I have time I will be back to read more, Please do keep up the fantastic work. https://goo.gl/maps/RLPF

institut de massage lyon To 九九 (2天以前)

Greetings from Idaho! I'm bored to death at work so I decided to browse your website on my iphone during lunch break. I really like the information you provide here and can't wait to take a look when I get home. I'm amazed at how quick your blog loaded on my cell phone .. I'm not even using WIFI, just 3G .. Anyhow, very good blog! https://goo.gl/maps/RLPFGxUQTms

institut massage lyon To 九九 (2天以前)

Greetings! I know this is kinda off topic but I was wondering which blog platform are you using for this site? I'm getting fed up of Wordpress because I've had problems with hackers and I'm looking at options for another platform. I would be fantastic if you could point me in the direction of a good platform. https://goo.gl/maps/RLPFGxUQTms

meilleur massage lyon To 九九 (2天以前)

Your method of explaining everything in this article is in fact fastidious, every one be capable of effortlessly be aware of it, Thanks a lot. https://goo.gl/maps/RLPFGxUQTms

massage lyon france To 九九 (3天以前)

Good article. I certainly appreciate this site. Continue the good work! https://goo.gl/maps/RLPFGxUQTms

soins massage lyon To 九九 (3天以前)

That is a good tip particularly to those fresh to the blogosphere. Simple but very precise information… Thanks for sharing this one. A must read post! https://goo.gl/maps/RLPFGxUQTms

spa massage lyon To 九九 (3天以前)

I'm not sure why but this web site is loading incredibly slow for me. Is anyone else having this problem or is it a issue on my end? I'll check back later on and see if the problem still exists. https://goo.gl/maps/RLPFGxUQTms

seance de massage lyon To 九九 (4天以前)

I am extremely impressed with your writing skills as well as with the layout on your weblog. Is this a paid theme or did you modify it yourself? Either way keep up the nice quality writing, it is rare to see a great blog like this one nowadays. https://goo.gl/maps/RLPFGxUQTms

massage lyon croix rousse To 九九 (4天以前)

In fact when someone doesn't be aware of after that its up to other viewers that they will help, so here it occurs. https://goo.gl/maps/RLPFGxUQTms

institut de massage lyon To 九九 (5天以前)

Hey there this is somewhat of off topic but I was wanting to know if blogs use WYSIWYG editors or if you have to manually code with HTML. I'm starting a blog soon but have no coding expertise so I wanted to get advice from someone with experience. Any help would be enormously appreciated! https://goo.gl/maps/RLPFGxUQTms

massage lyon croix rousse To 九九 (6天以前)

I think this is one of the most important info for me. And i'm glad reading your article. But want to remark on some general things, The web site style is wonderful, the articles is really great : D. Good job, cheers https://goo.gl/maps/RLPFGxUQTms

Patrice To 九九 (7天以前)

Great looking website. Think you did a bunch of your own coding. talks about it - internet - My Page - see this site - Read Much more - click this over here now - read this article - this content - his explanation - i loved this - Suggested Internet site - Click on astrahan.tehvolga.ru - this page - Going Here - this page - experienced - go!! - check out this site - advice here - Home Page - Read More Here - they said - on front page - address here - redirected here - i thought a

Ashely To 九九 (7天以前)

thank a lot for your internet site it assists a lot. click to read - the full details - click the following website - website link - image source - click through the next webpage - click through the up coming page - read review - go to website - visit the next site - official source - just click the next site - Read the Full Document - had me going - learn the facts here now - visit my home page - moved here - Continued - you could check here - similar internet site - Read hspinon

massage lyon spa To 九九 (7天以前)

Today, while I was at work, my sister stole my iPad and tested to see if it can survive a twenty five foot drop, just so she can be a youtube sensation. My iPad is now broken and she has 83 views. I know this is entirely off topic but I had to share it with someone! https://goo.gl/maps/RLPFGxUQTms

detente massage lyon To 九九 (7天以前)

Nice blog right here! Also your site so much up very fast! What host are you the usage of? Can I get your affiliate hyperlink to your host? I desire my web site loaded up as quickly as yours lol https://goo.gl/maps/RLPFGxUQTms

detente massage lyon To 九九 (2017-06-15)

If some one needs expert view concerning blogging and site-building afterward i propose him/her to go to see this blog, Keep up the pleasant job. https://goo.gl/maps/RLPFGxUQTms

massage lyon pas cher To 九九 (2017-06-13)

Admiring the hard work you put into your blog and detailed information you present. It's awesome to come across a blog every once in a while that isn't the same outdated rehashed information. Excellent read! I've bookmarked your site and I'm adding your RSS feeds to my Google account. https://goo.gl/maps/RLPFGxUQTms

Agen Bola Judi Casino To 九九 (2017-06-12)

Ⲛeeded to puut yoou thiks ⅼittle bbit оf remark tо thank yоu оnce again for tҺᥱsᥱ beautiful knowledge yοu'vе featured aЬove. It's quite tremendously opеn-handed off уou to deliiver unreservedly ԝhat a number of us wоuld'ѵe offered fοr sale forr an electronic book inn оrder to make ѕome profit foor themѕelves, ϲertainly givᥱn that you might havе done іt if you decided. Ꭲhese tricks additionally acted ⅼike a fantastic ѡay tto comprehend someone elsee have the identical zeal

PS:多打字可以减肥哦~234字以内。支持表情:


Top