mysql-windows-noinstall-python3-scripts

MySQL noinstall windows python3 scripts

# setup file

# run as admin
import os

cwd = os.getcwd()

mysql_dir = cwd.replace("\\", '/')
mysql_ini_file = "my.ini"

# sys.argv

print(f"current working directory {cwd}")

if os.path.exists(mysql_ini_file):
  os.remove(mysql_ini_file)

if not os.path.isfile(mysql_ini_file):
  f = open(mysql_ini_file, "w")
  f.write(f"""[mysqld]
# set basedir to your installation path
basedir={mysql_dir}
# set datadir to the location of your data directory
datadir={mysql_dir}/data
""")
  f.close()

if not os.path.exists("data"):
    os.makedirs("data")

os.system("bin\mysqld --initialize-insecure --console")

os.system("bin\mysqld --install-manual")

remove

os.system("bin\mysqld --remove")

start

import os
os.system("bin\mysqld --console")

stop

import os
os.system("bin\mysqladmin -u root shutdown")

up

# run as admin

import os

os.system('sc start MySQL')