Command line start MySQL.

-
Command line start MySQL.
sudo /usr/local/mysql/support-files/mysql.server start
To find the MySQL version from the terminal, type at the prompt:
/usr/local/mysql/bin/mysql -v
This also puts you in to a shell interactive dialogue with mySQL, type q to exit.

이 블로그의 인기 게시물

How to change ip address of mysql server

-
Changing and access the ip address of mysql server needs some of steps, usually it could be thought as just changing bind IP address in my.cnf file. (The default ip address of mysql server may be 127.0.0.1.) Steps, 1. Open my.cnf file The primary my.cnf is located in /etc/my.cnf. (Mysql server searches my.cnf files from multiple directories from /etc/my.cnf, /etc/mysql/my.cnf, $MYSQL_HOME/my.cnf, [datadir]/my.cnf, ~/my.cnf, etc. It could be different depend on the OS.) 2. Change bind-address field to IP address you want to set. For example, [mysqld] ... #bind-address = 127.0.0.1 bind-address = 62.168.0.100 (example ip address) And save the file. 3. Restart mysql process. The command could be different depend on  your OS. $ /etc/init.d/mysqld restart or $ service mysql restart or  $ sudo /usr/local/mysql/support-files/mysql.server restart   4. Grant the account access rights to connect the mysql server with the IP address remotely. Connect mysql ...
자세한 내용 보기

How to set password authentication with ec2-user of AWS

-
In fact, it would be problem to change instances of AWS to invalidate pem file(s) when one or some of system administrators or server side programmers / engineers leaves your group or company. But managing all of pem files by only one authorized person, it would be risky and tedious to do the job when the number of servers grows. For this situation, the traditional password authentication is the way to be acceptable.     There are some articles and sites about adding a new user with password to LINUX (or UNIX) server operated on AWS, or just dealing with pem file of ec2-user. But it is not easy to find the related things about applying password authentication with ec2-user clearly, although it is easy to do. And the most articles end with just creating the password for ec2-user, but it may not work for asking password whenever doing login. So, I'm writing how to apply the password authentication to ec2-user (default user) of AWS (LINUX / UNIX). Please do the f...
자세한 내용 보기

ai tools

-
  Audio Tools: 1. http:// Lovo.ai 2. http:// Speechify.com 3. http:// Murf.ai 4. http:// Media.io Website Builder Tools: 1. http:// 10web.io 2. http:// Durable.co 3. http:// Alliai.com 4. http:// Subpage.app Video Tools: 1. http:// Steve.ai 2. http:// Pictory.ai 3. http:// Deepbrain.io 4. http:// Heygen.com Research AI Tools: 1. http:// Paperpal.com 2. http:// Beta.monic.ai 3. http:// Consensus.app 4. http:// Perplexity.ai 5. http:// You.com Coding Tools: 1. http:// Tabnine.com 2. http:// Codium.ai 3. http:// Dora.run/ai 4. http:// Mutable.ai 5. http:// Superagi.com Presentation Tools: 1. http:// Beautiful.ai 2. http:// Simplified.com 3. http:// Slidesgo.com 4. http:// Sendsteps.com Content Creation Tools: 1. http:// Lovo.ai 2. http:// Writesonic.com 3. http:// Jasper.ai 4. http:// Stockimg.ai 5. http:// Copy.ai
자세한 내용 보기