linux - MySQL installation from deb, permissions issues -

-

I'm trying to install MySQL on Microsoft 14.04 from deb package. I'm having trouble starting mysql server, it looks like a permission problem I followed the steps I mentioned. Download / Unreserved / Installed Deb Tark Bundle. 

  sudo apt-get install libaio1 tar -xvf mysql-server_5.7.4-m14-2ubuntu14.04_amd64.deb-bundle.tar md5sum mysql-server_5. 7.4-M14-2UNTUU 14.04_AMDI 64. ADB-Bundle. Sudo DPKG-Eye MySQL-Common_5.7.4-M14 Ubuntu 14.04_AMD64. Deb Shadow DPKG-IISLL-Community-Server_7.4.4-M14 Ubuntu 14.04_Amdi 64. Deb Schuo Dpkg -i mysql-community-client_5.7.4- M14-214.04_Amadi64.deb sudo dpkg -i libmysqlclient18_5.7.4-m14-2ubuntu14.04_ amidi 64.deb

This is where the files are installed on my system: All configuration files (Such as my.cnf ) under / etc . All binaries, libraries, headers, etc. are under the data directory under the / var .

I am creating a MySQL group and user: 

  groupadd mysql useradd -r -g mysql mysql

I change the ownership of mysql scripts to mysql (according to instructions, but it is doubtful that it is necessary) 

  CD / User / Bin Sudo Crown MySQL MySak sudo chgrp Mysql mysq *

I run mysql_install_db to set the grant table 

  sudo mysql_install_db --user = mysql

I'll switch back to ownership and Root mysql group of scripts 

  cd / usr / bin sudo chown root mysq * sudo chgrp root mysq *

I / data mysql on location / var / lib / mysql 

  cd / var / lib ls -l mysql Total 122896 -Rye-RY-RW-1sssl mysql 56 July 26 10:17 auto.cnf-rw-rw-rw-1 mysql mysql 12582912 July 26 10:17 Ibadata 1-R-R-R-1-1 MySQL ISSL 50331648 July 26 10:17 IB_LogFile -R- R-R-1-R1-1 MYSQL mysql 50331648 July 24 17:36 ib_logfile1-rw-rw ---- 1 mysql mysql 12582912 July 26 10:17 ibtmp1 drwxrwxrw- 2 mysql mysql 4096 July 24 17:36 mysql drwxrw -rw-2 mysql mysql 4096 July 24 17:36 Performance_schema   
 Now, when I try to start the  mysql  server, I get permission errors:    P>   mysqld_safe --user = mysql & amp; [4] 5680 / var / lib $ 140727 00:42:17 '/var/log/mysql/error.log' to mysqld_safe logging. Cat: /var/run/mysqld/mysqld.pid: Permission denied RM: Can not delete '/var/run/mysqld/mysqld.pid': Permission denied 140727 00:42:17 mysqld_safe Fatal error: do not delete the pid File: /var/run/mysqld/mysqld.pid Please manually delete it and start / usr / bin / mysqld_safe again; Mysqld daemon did not start / usr / bin / mysqld_safe: 129: can make / usr / bin / mysqld_safe: /var/log/mysql/error.log: permission denied

similarly , If I try to start the server as root: 

  mysqld_safe -p -u root 140727 00:54:08 to mysqld_safe logging '/ var / log / mysql / Error.log '. 140727 00:54:08 mysqld_safe / var / lib / mysql / usr / bin / mysqld_safe: 129: / usr / bin / mysqld_safe can start mysqld daemon with the database: /var/log/mysql/error.log : Permission denied / usr / bin / mysqld_safe: 1: eval: can create /var/log/mysql/error.log: permission denied 140727 00:54:08 from mysqld_safe mysqld pid file / var / run / mysqld / mysqld. Pid end / usr / bin / mysqld_safe: 12 9: can create / usr / bin / mysqld_safe: /var/log/mysql/error.log: permission denied

apparently there There are many places where I should change permissions, which do not see the way to go N:

  1. What should a clear point where I went wrong, or I should just cancel the installation and see everything?

  2. Do the owners need to update MySQL and group mysql which server needs to be updated?

  3. Is there a comprehensive list of files where these files are?

You can not create /var/log/mysql/error.log First create the directory if it does not exist 

  sudo mkdir -p / var / log / mysql

Next, change ownership 

  sudo chown-r mysql / var / log / mysql

and then try to start the server as root: 

  Sudo mysqld_safe --user = isssl & amp;

If the server does not paste error messages here


Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

java - Gradle dependencies: compile project by relative path -

-
Is it possible to specify a dependency on another gradeal project in the granular (in android studios) outside the current project limits? For example, with a relative path like this: dependence {collection project ('../../ stdlib / dagger'}} MyApp (path / user / foo / workspace / mypad) The app (Path / User / Foo / Workspace / MyPass / App) And I have an Android Library Project with 3 subdomules: stdlib (path is / user / foo / Utilities (Path / User / Foo / Workspace / Stadlib / Utilis) http (Path / User / Foo / Workspace / Stadlib / HT) / Li> What I have to do is compile the Dagger, Util, http module in the MyApp project. The Stidelib Library module under heavy development And MyApp will grow in the form of Growth, so I do not want to push them into a Mewen repository. I am a little change. is likely to add another Gredle projects in some way? I will push the study library into the Maven repository after the source is in search of a temp...
Read more

ruby on rails - Object doesn't support #inspect when used with .include -

-
So I have participated in a glitch error that I do not even know how to debug. I am very new to the railing, so it has kicked my ass well when I use the .includes (school) seen by the student, it gives a blue box error, But when I look at any other model and .includes (school) , the school works just fine. class student & lt; ActiveRecord :: Base has has_many: relationships, foreign_key: "liker_id", dependent :: has_many: matches, foreign_key: "student_1_id", dependent :: deleted belong_to: school belong_to: conference belong_to: would_you_rather belong_to: home city belong_to: year is_to: Major and class school & lt; on the console activatecord :: Affiliate for the base: conference includes: respondent, class: "school", foreign_key: "rival_id" (e.g. For: School) Select SQL generated Select "School". * "School" from "school" "ID" IN (1) error message back NoMethodError: u...
Read more