PowerShell script to get Mobilijeune's quota
Used and tested with PowerShell 5.1 (Windows) and PowerShell 7.1 (Debian)
- An up and running MySQL Database Server
- The SimplySQL PowerShell's module :
# Install the SimplySQL module :
Install-Module -Name SimplySQL
- Optional but useful : phpMyAdmin
CREATE DATABASE mobilibot;
CREATE TABLE mobilitable (
testid int NOT NULL AUTO_INCREMENT PRIMARY KEY,
resultcode int NOT NULL,
time datetime
);
CREATE USER 'user'@localhost IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'user'@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;