(windows) cant connect to mysql

[vodish]

error

man

setup

what am I doing wrong?

[vodish]

[vodish]

playgroud
https://play.vlang.io/p/ab902ed437

Running code...
Can't run code. The server returned an error:
builder error: Header file , needed for module `db.mysql` was not found. Please install the mysql headers.
Exited with error status 1
Please try again.

[jorgeluismireles]

I search for old issues about mysql, for example, #14464 and think both PG, Mysql are not usable yet... If you really nead SQL try sqlite works ok.

[vodish]

Hm... and I've already rewrote the API for my website on your beautiful V.
All that remains is to connect to the database

[Wajinn]

We have to be cautious, before saying something is not solvable. Seen this, not just here, but many times and in many other situations (including outside programming). 1) Those who might be able to solve the problem, have not seen it yet (everybody has a different schedule), so we have to show more patience. 2) The person submitting the problem, might realize there was a way to do it (as in this case). The problem might not be the language, OS, or anything external. Just our mistake or failing to notice something.

[vodish]

solution

1. install wsl2 for windows (ubuntu)

2. open terminal in wsl

3. sudo apt update

4. sudo apt install git build-essential

5. cd /usr/lib
   "/usr/lib" is a dir for langs for ubuntu

6. inslall V
   git clone --depth=1 https://github.com/vlang/v
cd v
make

7. sudo ./v symlink
   create symlink

8. sudo apt install libmariadb-dev
sudo apt install pkg-config
   for mariadb/mysql

ps.
it is worked for my and i am happy ))

[vodish]

test code

module main

import db.mysql

fn main() {
	config := mysql.Config{
		host:     '127.0.0.1'
		port:     3306
		username: 'root'
		password: 'toor'
		dbname:   'test'
	}

	mut conn := mysql.connect(config) or { panic(err) }
	
	res := conn.query('SHOW TABLES') or { panic(err) }
	for row in res.rows() {
		println(row.vals.join(', '))
	}
	conn.close()

}