|
1 day ago | |
---|---|---|
assets | 1 year ago | |
.gitignore | 1 year ago | |
README.md | 1 year ago | |
htaccess.template | 1 year ago | |
index.html | 3 days ago | |
index_simple.html | 1 day ago | |
word_admin.html | 1 year ago |
Clone the repo git clone https://gitlab.com/tigexplorer/wordcloud.git
Prevent accessing git files from the web, activate and edit the htaccess file
mv htaccess.template .htaccess
nano .htaccess
Set admin access (creating .htusers_wordcloud with user/ password,
replace my-web-path with yours path, replace myAdminUser with yours)
htpasswd -c my-web-path/.htusers_wordcloud myAdminUser
Create database
mysql -u MYUSER -p
create database `wordcloud`;
grant CREATE,ALTER,SELECT,INSERT,UPDATE,DELETE,INDEX,DROP on `wordcloud`.* to 'MyWordcloudUSER'@'localhost' identified by 'MyPassword';
SHOW databases;
SELECT User FROM mysql.user;
Create tables
USE wordcloud;
CREATE TABLE IF NOT EXISTS words (
word_id INT AUTO_INCREMENT,
word VARCHAR(255) NOT NULL,
PRIMARY KEY (word_id)
) ENGINE=INNODB;
SHOW TABLES;
Set db access
cp assets/php/db_conf_pdo.inc.php.template assets/php/db_conf_pdo.inc.php
nano assets/php/db_conf_pdo.inc.php