Java/DB – 乐猫的家园

服务器开发之—Redis

1.安装（Mac)

 1. 官网<a href="http://redis.io/" rel="nofollow">http://redis.io/</a> 下载最新的稳定版本,这里是3.2.0

 2. sudo mv 到 /usr/local/

 3. sudo tar -zxf redis-3.2.0.tar 解压文件

 4. 进入解压后的目录 cd redis-3.2.0

 5. sudo make test 测试编译

 6. sudo make install


win:https://github.com/ServiceStack/redis-windows

1. 官网<a href="http://redis.io/" rel="nofollow">http://redis.io/</a> 下载最新的稳定版本,这里是3.2.0

2. sudo mv 到 /usr/local/

3. sudo tar -zxf redis-3.2.0.tar 解压文件

4. 进入解压后的目录 cd redis-3.2.0

5. sudo make test 测试编译

6. sudo make install

win:https://github.com/ServiceStack/redis-windows

2.启动连接

<span class="s1">1.启动服务：redis-server
</span>  启动服务：redis-server ./redis.conf     #加载配置

2.连接： <strong>redis-cli -h 127.0.0.1 -p 6379</strong> 
3.设置键值对： <strong>set myKey abc</strong>
4.取出键值对： <strong>get myKey</strong>

1.启动服务：redis-server

启动服务：redis-server ./redis.conf #加载配置

2.连接： redis-cli -h 127.0.0.1 -p 6379

3.设置键值对： set myKey abc

4.取出键值对： get myKey

3.关闭服务

redis-cli shutdown

1	redis-cli shutdown

&[……]

服务器开发之—Java问题汇总

工作十余载，常憾浅尝辄止于各种技术，亦曾屡试专攻于一技，怎奈现实总不能遂人意，为了生活，只能不断前进再前进….

游戏服务器开发掌握的技能：
1）语言：Java(Lua,Python Linux Shell etc.) 教程：Java 教程; 《Java程序员修炼之道》
2) 网络[……]

服务器开发之—MariaDB(MySql)

安装

Max-MacBook-Pro:~ Max$ brew install mariadb
==> Downloading https://homebrew.bintray.com/bottles/mariadb-10.2.7_1.sierra.bot
######################################################################## 100.0%
==> Pouring mariadb-10.2.7_1.sierra.bottle.tar.gz
==> Using the sandbox
==> /usr/local/Cellar/mariadb/10.2.7_1/bin/mysql_install_db --verbose --user=Max
==> Caveats
A "/etc/my.cnf" from another install may interfere with a Homebrew-built
server starting up correctly.

MySQL is configured to only allow connections from localhost by default

To connect:
    mysql -uroot

To have launchd start mariadb now and restart at login:
  brew services start mariadb
Or, if you don't want/need a background service you can just run:
  mysql.server start
==> Summary
🍺  /usr/local/Cellar/mariadb/10.2.7_1: 623 files, 162.2MB

Max-MacBook-Pro:~ Max$ brew install mariadb

==> Downloading https://homebrew.bintray.com/bottles/mariadb-10.2.7_1.sierra.bot

######################################################################## 100.0%

==> Pouring mariadb-10.2.7_1.sierra.bottle.tar.gz

==> Using the sandbox

==> /usr/local/Cellar/mariadb/10.2.7_1/bin/mysql_install_db --verbose --user=Max

==> Caveats

A "/etc/my.cnf" from another install may interfere with a Homebrew-built

server starting up correctly.

MySQL is configured to only allow connections from localhost by default

To connect:

mysql -uroot

To have launchd start mariadb now and restart at login:

brew services start mariadb

Or, if you don't want/need a background service you can just run:

mysql.server start

==> Summary

🍺 /usr/local/Cellar/mariadb/10.2.7_1: 623 files, 162.2MB

手动启动

Max-MacBook-Pro:~ Max$ mysql.server start
Starting MySQL
.170729 10:12:17 mysqld_safe Logging to '/usr/local/var/mysql/Max-MacBook-Pro.local.err'.
170729 10:12:17 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
 SUCCESS!

Max-MacBook-Pro:~ Max$ mysql.server start

Starting MySQL

.170729 10:12:17 mysqld_safe Logging to '/usr/local/var/mysql/Max-MacBook-Pro.local.err'.

170729 10:12:17 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql

SUCCESS!

连接数据库

Max-MacBook-Pro:~ Max$ mysql -uroot
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.2.7-MariaDB Homebrew

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Max-MacBook-Pro:~ Max$ mysql -uroot

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 9

Server version: 10.2.7-MariaDB Homebrew

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

执行命令：
[crayon-5d0af4c34c437766[……]