How do you start a MySQL server on linux? -

-

pretty simple question here. want sql database on version of kali linux can practice sql.

i opened command line , entered tried start mysql , error.

> mysql -u root error 2002 (hy000): can't connect local mysql server through socket '/var/run/mysqld/mysqld.sock'

i made sure installed using apt-get.

what steps need take able make database tables , data can query?

i don't know kali, on ubuntu be

$ sudo service mysql start

once command returns, mysqld service has started, can use mysql client connect it.

of course, have make sure have mysql-server package installed, not mysql-client , mysql-common, , you've initialized database instance. complete post-installation instructions can found in the official documentation, short version is

  1. make sure installer has created mysql user account. account "own" server process once starts.
  2. change data directory. (i used installer's default of /var/lib/mysql; can change editing my.cnf.)

  3. as root, execute server daemon --initialize switch. check whereis determine correct path, then

    $ sudo /path/to/mysqld --initialize --user=mysql

  4. this command twiddle while, display automatically-generated password , exit. once command returns, database instance has been initialized , system tables created. can start database instance (using service start), log in database user root (which not same system user root) using password above, change password, create new database user, log in that user, create user database, , start creating tables.

again, the official documentation place this; if of instructions in the official documentation differ instructions, should ignore me , follow the official documentation's instructions.


Comments

Post a Comment

Popular posts from this blog

javascript - Feed FileReader from server side files -

-
i´m starting customize/improve old audio editor project. can import audio tracks canvas via drag&drop computer. thing use audio tracks stored in server clicking on list of available tracks... instead of use <input type="file"> tags. how can read server side files filereader?ajax perhaps? in advance. this code file reader: player.prototype.loadfile = function(file, el) { //console.log(file); var reader = new filereader, filetypes = ['audio/mpeg', 'audio/mp3', 'audio/wave', 'audio/wav'], = this; if (filetypes.indexof(file.type) < 0) { throw('unsupported file format!'); } reader.onloadend = function(e) { if (e.target.readystate == filereader.done) { // done == 2 $('.progress').children().width('100%'); var onsuccess = function(audiobuffer) { $(el).trigger('audiee:fileloaded', [audiobuffer, file]); ...
Read more

How to Change swipe Tab Title color in java Android -

-
by default, view pager(swipe tabs) tab title color white want change orange. can 1 me please or share if have tutorial. thanks... use style in styles.xml , assign style tab layout. <style name="mymaterialtheme.tablayout" parent="widget.design.tablayout"> <item name="tabindicatorcolor">@android:color/white</item> <item name="tabindicatorheight">3dp</item> <item name="tabtextappearance">@style/mymaterialtheme.tablayout.textappearance</item> <item name="tabselectedtextcolor">@android:color/white</item> <item name="android:background">@color/colorprimary</item> </style> <style name="mymaterialtheme.tablayout.textappearance" parent="textappearance.design.tab"> <item name="android:textsize">14sp</item> <item name="android:textcolor">@color/tab_text_inactive</item> ...
Read more

php - how to give proper permission for pcntl_exec? -

-
i trying fork php script , execute php script using pcntl_exec command, getting following error: pcntl_exec(): error has occured: (errno 13) permission denied i trying following code after normal forking in function: $pathtofile="/var/www/html"; $outputfile =array("mytestfile.php"); if ($pid) // parent { $pid_arr[$i] = $pid; } else // child { pcntl_exec($cmd,$outputfile); return "error occurred in child"; } all other pcntl functions working properly, tried chmod , chown commands on directory well, still pcntl_exec not working. please tell me doing wrong? thanks in advance!! try option: chmod 755 /var/www/html this should grant permission needed!
Read more